formatting minutes & seconds, then adding them

  • Thread starter Thread starter greggd
  • Start date Start date
G

greggd

I'm trying to get cells to format minutes and seconds ( I
always get AM & PM when I format the cell under "time").
I'm trying to add minutes and seconds to get a total time
for running a race.
Any help is appreciated.
Gregg
 
Try using the custom format [h]:mm:ss. You will always see the AM or PM in
the formula bar, but it should'nt affect your calculation.

HTH
Mike
 
Back
Top