Excell time sheet

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

i am attempting to create a time sheet for work using
excell 2003 and i have done fairly well untill it
calculates any time that goes from pm to am ex. 7 pm to
7am the formula that i wrote is =SUM((F11-E11)*24,(D11-C11)
*24) it allways caculates a negitive value if anyone has
any input i would appreciate it
 
Hi Rob,

Try this:

=SUM(F11-E11+(E11>F11),D11-C11+(C11>D11))*24

This formula accounts for times that roll past midnight.
Format as General.

Biff
 
Back
Top