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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

=sum(B2,E2)

format the cell as time.

If the time will exceed 24 hours use a custom format

[h]:mm:ss

Also, In general, excel will not display a negative time. You would have to
change to the 1904 base time system to work with negative times. I only
say that because you show 13:24:45 - 13:32:54 = ? which would produce a
negative time.

--
Regards,
Tom Ogilvy

ximian <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>

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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Try using ABS()?

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

Format C1 as h:mm:ss

ximian <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.