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

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 [email protected]> wrote in message
news:[email protected]...
> 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 [email protected]>
wrote in message
>news:[email protected]...
>> 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 [email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>
>