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
|