Timesheet calculations

[Brainiac58]

Hello all-

I am working on a database that will help supervisors schedule staff for hours. I have a field for start time (StartTime) and End time (EndTime) and want to calculate to hours worked each shift and hours of overtime worked each shift. I had the calculation for total hours worked as (EndTime-StartTime) with the result set as a number. When I enter in a start time of 5:30 and an end time of 15:00, I get 3420. Can anyone tell me what I need to do to fix this calculation? Thanks.

[mr_vodka]

It needs to be a time result. Also do a quick search for

+subtracting +time

and you will come across posts regarding this matter as well as compensating for crossing midnight.

[Brainiac58]

Thanks for the direction! Those posts had exactly what I was looking for ;)