Convert to seconds problem

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi all,

We use Excel 2002 to record laptimes (racing) in the
format mm:ss.000

I need to convert that value to "seconds.milliseconds" but
cannot seem to get it right.

For example, a cell contains a laptime of 02:39.780, which
must be converted to:

2 x 60 = 120
plus 39.780 = 159.780 seconds

What formula do I need to use?

Thanks a lot.
 
Hi Chris!

Use:

=A1*(24*60*60)

Time is recorded as a decimal portion of a day. So multiplying by
24*60*60 converts to seconds

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Chris,

Time in excel "is a value ranging from 0 to 0.99999999, representing
the times from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.)."
ie. it's stored as fractions of a day

You can convert...

=A1*24*60*60
=Value * 24 (hours/day) * 60 (minutes/hour) * 60 (seconds/minute)
=Time in seconds

If it appears incorrectly make sure your cell is formatted to display
a number and not a date/time.

Dan E
 
Back
Top