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?

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
##":"##.##

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Garth Hales" <Garth wrote in message
...
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?

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

-----Original Message-----
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
##":"##.##

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Garth Hales" <Garth
wrote in message
...
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?


.

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

"Fred Smith" wrote:

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
##":"##.##

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Garth Hales" <Garth wrote in message
...
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?