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 Type
10/1/2008 10:16:58 AM In
10/1/2008 2:40:05 PM Meal
10/1/2008 3:15:02 PM In
10/1/2008 5:38:22 PM Out


See More: Excel to convert work punches to total hours

Report •

#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


Ask Question