MrExcel Publishing
Your One Stop for Excel Tips & Solutions

number to time


Posted by Erik on February 20, 2001 3:20 PM

Can I convert a number in a cell to time format?
Ex: 104530 = 10:45:30

Thanks!


Posted by David Hawley on February 21, 2001 1:14 AM

Hi Eric

You can use this:

=TIMEVALUE(LEFT(D3,2) & ":" & MID(D3,3,2) & ":" & RIGHT(D3,2))

Then format your cell as a time format.


Dave


OzGrid Business Applications

Posted by Dave Hawley on March 05, 2001 8:49 AM

OzGrid Business Applications

Posted by Dave Hawley on March 05, 2001 8:49 AM

OzGrid Business Applications