formula?

[JBell]

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?

 

[MyVeryOwnSelf]

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.)