Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert number to time | Excel Worksheet Functions | |||
How do I convert a time to text format. | Excel Discussion (Misc queries) | |||
Convert data into standard military time format | Excel Discussion (Misc queries) | |||
How do convert time into numeric | Excel Worksheet Functions | |||
convert number to time format? | Excel Discussion (Misc queries) |