Microsoft Corporation download - microso...

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

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 OutWill you have to deal with different pay rates for different times of the day?

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.

Actually, I got 6.7742. =((B3-B2+B5-B4)-INT(B3-B2+B5-B4))*24

Ask Your Question

Weekly Poll