Thread: formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf[_2_] MyVeryOwnSelf[_2_] is offline
external usenet poster
 
Posts: 143
Default formula?

Can you help me figure out a Excel formula? I am trying to make a time
card for my boss. With 4 fields. Time-in | Time-Out | Break | Total:
My formula reads =(E11+F11)-(G11)*24 It should give me 8 hours
worked. What am I doing wrong?


If
E11 = time in (start of shift); e.g., 8:00:00
F11 = time out (end of shift); e.g., 17:00:00
G11 = length of break (hours); e.g., 1:00:00
then
=24*(F11-E11-G11)
gives the number of hours worked. Format it as a number.

It would get more complicated if the shift can span midnight.

(I have Excel 2003.)