I need to determine the amount of time a process took. It begain at
23:21:32pm and finished at 8:29:29am. The total time = 9:07:57 (9hrs 7min
57sec). I need a formula to calculate the total time. The formual I tried
=text(b10-b9,"h:mm:ss") and that produced #VALUE!. I changed to the 1904
date system under tools/options/calculation and that produced -14:52:03. If
I could convert that negative to a positive from 2400 hrs then I would have
the correct answer. Any insight would be greatly appreciated.... please and
thank you. :) I'm using excel 2003 microsoft office professional edition.