Thanks for writing back so quickly!

I tried that and got 2:01 rather than 26:01. That formula doesn't seem to
be taking into account that it spans a day plus the 2 hours and one minute.
It is missing 24 hours!

"JE McGimpsey" wrote:

If you've got it formatted the way you want, just subtract:


A1: 8/15/2005 9:30 AM
A2: 8/16/2005 11:31 AM
A3: =A2 - A1 === 26:01


In article ,
"dtencza" wrote:

I realized after I posted this that Cell A2 should say '8/16/2005 11:31 AM'
in my example.

I have the cell formatted the way I want, I just can't get the calculation
correct if the dates span over a day If anyone has made a formula that does
this and can share it, I'd be really grateful.