Convert Time Calculation

[jodiefrench]

I need to convert the elapsed hours calculation and am hoping someone here can help.

All hours are entered in 15 minute increments. My calculation (as an example) for an employees hours of 7:00AM - 3:30PM comes out as 8:30:00.

I need the result to read that he worked 8.5 hours, so that it can be easily entered into the payroll program.

How can I modify my current calc to achieve this answer?

Mod ( ApptResEmp_TimeOut - ApptResEmp_TimeIn + 864000;86400)

Thanks!

[comment]

How about:

Mod ( ( EndTime - StartTime ) / 3600 ; 24 )

[jodiefrench]

Thanks - that worked perfectly!