Excel - dd/mm/yy hh:mm:ss formula 1

[brunnle2]

I have two Date & Time columns (dd/mm/yyyy hh:mm:ss). One is an open time, and another is the closed time. What I need to calculate in hours, is what is the elapsed time between the two. Closed Time - Open Time works if time elapsed is <24 hours. anything >24 hours and the elapsed time goes back to 0.
How can I change this?

 

[AnotherHiggins]

Change the format of the cell to [h]:mm:ss

[tt]_____
[blue]-John[/blue]
[/tt][red]"I'm against picketing, but I don't know how to show it."[/red]
-Mitch Hedberg

Help us help you. Please read FAQ181-2886 before posting.