# Excel to convert work punches to total hours

Microsoft Corporation download - microso...
October 1, 2010 at 12:28:30
Specs: Windows XP
 Could someone tell me the formula for the data set below, in order to tell me how many hours this person worked in the day? i know the answer is 6.76 but need to know the formula used.thanks,Date Time Type10/1/2008 10:16:58 AM In10/1/2008 2:40:05 PM Meal10/1/2008 3:15:02 PM In10/1/2008 5:38:22 PM Out

See More: Excel to convert work punches to total hours

#1
October 1, 2010 at 12:49:36
 Do we have to deal with shifts that cross midnight?e.g.: Date Time Type 10/1/2008 10:16:58 PM In 10/2/2008 2:40:05 AM Meal 10/2/2008 3:15:02 AM In 10/2/2008 5:38:22 AM Out Will you have to deal with different pay rates for different times of the day?

Report •

#2
October 1, 2010 at 13:21:12
 Fortunately, the data i am working with does not have any overnight shifts nor will i have to deal with any shift differential pay.thanks.

Report •

#3
October 1, 2010 at 13:45:27
 Actually, I got 6.7742.=((B3-B2+B5-B4)-INT(B3-B2+B5-B4))*24

Report •

Related Solutions