convert time to numerical vale

[Guest]

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

Thanks in advance!
Meg

 

[Guest]

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

Hope this helps,
Miguel.

 

[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

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

 

[daddylonglegs]

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

Thanks in advance!
Meg

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

 

[Guest]

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!

 

[Guest]

I get a value error when I multiply the 1:04.69 * 86400.

 

[Franz Verga]

Nel post *Meg* ha scritto:

I get a value error when I multiply the 1:04.69 * 86400.

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

 

[Guest]

That worked, thanks!