convert time to numerical vale

M

Miguel Zapico

You can use a custom format like:
[ss].00
Or the TEXT function, with that format:
=TEXT(A1,"[ss].00")

Hope this helps,
Miguel.
 
F

Franz Verga

Nel post *Meg* ha scritto:
Is there a way to convert a time of 1:04.69 to 64.69 in excel?

Thanks in advance!
Meg
Click to expand...

Hi Meg,

could you explain which kind of time is it?

Is 1 hour 4 minutes and 69 seconds or 1 minute and 4.69 seconds?


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
D

daddylonglegs

Meg said:
Is there a way to convert a time of 1:04.69 to 64.69 in excel?

Thanks in advance!
Meg
Click to expand...

if you want to convert a time to seconds multiply by 86400 (the numbe
of seconds in a day), e.g.

=A1*86400

where A1 contains your time

format result cell as numbe
 
M

Meg

It is 1 minute, 4.69 seconds. Used for a database of swimming times to
determine what the time was the first time the event was swam in a season and
the number of seconds taken off each time it is swam after the first time.

Thanks!
 
F

Franz Verga

Nel post *Meg* ha scritto:
I get a value error when I multiply the 1:04.69 * 86400.
Click to expand...


Maybe you inputed the time as a text, instead of time. Try this:

=Value(A1)*86400

where you have to change A1 with that one in which you have your time.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Top