date & time formulas HELP !!



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



04/07/2010 15:00:00 is bigger than 04/07/2010 00:00:00


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.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question