Difference between two timestamps

All,

I have two timestamp fields from which I need to extract the difference.

Please Login or Register  to view this content.

The formula is B2-A2 and the Difference field is a custom field using h:m:s.

As you can see, the difference is correct, except in military time. The correct answer should be 5:41:33.

What can I do to correct this?

formattime.png

Format the cell to AM/PM.

That corrects the format of the time, but I don't need to display AM/PM. I just want to know the difference in HMS so I can total it up at the end of the worksheet.

Then format it as number. Sum the seconds.

Okay... That makes sense. However, when I get to the point of totaling the seconds, how do I convert that to h:m:s with out AM/PM or military time?

=TEXT(B1-A1,"h:mm")

Wow. I completely missed the obvious. Thank you for clarifying!