date & time formulas HELP !!

  • Thread starter Thread starter Mayte
  • Start date Start date
M

Mayte

Hi -
i have to find out how long did it take to solve a case. the formaul is
(time completed) - (time created) my problem is when files are closed at
midnight because of the format ... any ideas how to fix it???

Column A = time created
Column B = time completed
Column C = Duration (in hours only)

timeCreated timeCompleted Duration
04/07/2010 15:00:00 04/07/2010 00:00:00 should be 9:00:00

Cheers,
Mayte
 
04/07/2010 15:00:00 is bigger than 04/07/2010 00:00:00

Try

04/07/2010 23:59:59 in A1 and 00:00:01 in cell B1 and try formula A1+B1

04/07/2010 23:59:59 is followed by 04/08/2010 00:00:00


So the below formula should work fine.
=B1-A1

and format the formula cell to [h]:mm:ss
 
Back
Top