I need to calculate to the nearest quarter hour; Worked 8 am - noon, 7:15 AM - 5:45 PM, 7:15 AM-5:45 PM, 8:30 am-4:30 pm. 5:30 pm -7:15 pm. I am getting 34.75 hours worked, is this correct or am I miscalculating my time worked?
Como
4 + 10•5 + 10•5 + 8 + 1•75 = 34•75 hours
Sqdancefan
For the numbers given, your sum is correct.
If the time periods you list include a lunch break, make sure you're getting a paid lunch break before you count it as time worked. Claiming time that wasn't worked is generally grounds for termination.
DWRead
Use a 24-hour clock
12:00 - 8:00 = 4:00
8am to noon is 4 hours
17:45 - 7:15 = 10:30
7:15am to 5:45pm is 10.5 hours
16:30 - 8:30 = 8:00
8:30am to 4:30pm is 8 hours
19:15 - 17:30 = 1:45
5:30pm to 7:15pm is 1 hour and 45 minutes = 1.75 hours
4 + 2·10.5 + 8 + 1.75 = 34.75 hours
User
One way to do it is to convert all times to minutes.
You do this by
AM times - multiplying 60 times the hour and adding that number to the minutes
PM times - multiplying 60 times (12 + the hour) and adding that number to the minutes
So, for example:
7:15 AM - 5:45 PM
start = 7 * 60 + 15 = 435
end = (5 + 12) * 60 + 45 = 1065
time worked
1065 - 435 = 630 minutes
now divide by 60 to get the hours, remainder equals minutes
hours = 10, minutes = 30
SO:
convert all times to minutes
subtract starting times from ending times to get time worked each shift
add the results of all the time worked
convert that to hours and minutes dividing by 60
Codie
It is correct.