Formular for Times

  • Thread starter Thread starter Kenno
  • Start date Start date
K

Kenno

Hi
Im looking for away to add working hour, that go into the nex
day, eg. 22:30 till 07:15.
=sum(B1-A1) only seems to work when hours are all in 1 day.
Im using excel 2002

Any suggestions would be much appreciated !
Kenn
 
Hi
Im looking for away to add working hour, that go into the next
day, eg. 22:30 till 07:15.
=sum(B1-A1) only seems to work when hours are all in 1 day.
Im using excel 2002

Any suggestions would be much appreciated !
Kenno
Click to expand...

1. Even in your formula, there is no need for the SUM function.

2. =B1-A1+(A1>B1) is the usual solution, so long as the time being measured
is less than 24 hours. If the time is more than 24 hours, you will need to i
include date information.


--ron
 
Back
Top