Track time in HH:min.min(Decimal) format

G

Garth Hales

I'm trying to accumulate elapsed times in a decimal minute format, i.e.
12:00.00 plus 1'30" = 12:01.50. Any ideas?
 
F

Fred Smith

Go with the flow and use hh:mm:ss like everyone else?

If not, I would probably put the hours and minutes in separate cells, then
combine them with the formula =a1*100+b1, and display with the format
##":"##.##
 
B

Biff

Hi!

If you go with a format like this: h:mm.ss

A1 = 12:00.00
B1 = 1'30"

=A1+(--SUBSTITUTE(SUBSTITUTE(B1,"'",":"),"""",""))/60

Formatted as h:mm.ss returns - 12:01.30

I could probably get 12:01.50 but I don't have time to
tinker with it.

Biff
 
G

Garth Hales

Thanks Fred, I'll try that. Like you say, I can go with the hh:mm:ss but it
is much easier to do intermediate hand calculations in a decimal format.
This is for TSD rallying. Thanks again

Garth
 
Top