convert time to numerical vale
 

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

Thanks in advance!
Meg

convert time to numerical vale
 

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

Hope this helps,
Miguel.

"Meg" wrote:

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

Thanks in advance!
Meg

convert time to numerical vale
 

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

convert time to numerical vale
 

Meg Wrote:
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 number
of seconds in a day), e.g.

=A1*86400

where A1 contains your time

format result cell as number


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=555147

convert time to numerical vale
 

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!

"Meg" wrote:

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

Thanks in advance!
Meg

convert time to numerical vale
 

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

"Meg" wrote:

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

Thanks in advance!
Meg

convert time to numerical vale
 

Nel post
*Meg* ha scritto:

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

"Meg" wrote:

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

Thanks in advance!
Meg


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

convert time to numerical vale
 

That worked, thanks!

"Meg" wrote:

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

Thanks in advance!
Meg