time format
Posted by John S. on March 13, 2001 12:55 PM
how can I get a number to act as a time EX
23 = 00:00:23
123=00:01:23
123456=12:34:56
Posted by Mark W. on March 13, 2001 1:33 PM
Divide it by 1440 and format it as a date value.
Posted by Mark W. on March 13, 2001 1:48 PM
Oops! Jumped too quickly...Let me ponder this one
Posted by Mark W. on March 13, 2001 2:23 PM
Okay! This is much better... : )
If your value is in cell A1, then use...
{=SUM(MID(REPT(0,6-LEN($A1))&$A1,{5,3,1},2)/{86400,1440,24})}
...and format the resulting value as hh:mm:ss
