Adding Time...

[ximian]

I have a question about adding time in 24 hour format. I like to record
a set of recorded times for my track team.

Format I am using at the moment.

HH:MM:SS

13:24:45 - 13:32:54 = ?

I want excell to add the time but for some reason I am not doing it
correctly. What I did is =sum(b2+e2) etc etc... I get an error or the
time format shows the time AND the date. I just want to display time
with the outcome.

Any help would be appreciated, standing by.

 

[ximian]

So, from what I take it I am not able to extract a value from this?

13:24:45 - 13:32:54 = 8:09 (8minutes and 09 seconds.) I may need to
swap the integers around so that I do not get a negative value...
(Correct?)

I use military time, easier for me, also none of my times will exceed
an hour if not 24 hours.

 

[Max]

Try using ABS()?

Put in C1: =ABS(A1-B1)
where A1: earlier time, B1: later time

Format C1 as h:mm:ss