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