Change a number to time
Posted by Kerry on September 18, 2001 2:52 PM
I have a column of data that I need to convert in to a time formet. Currently the data is
Example if A2 has the number 10652, 106 represents the total hours and 52 represents the minutes.
I need it formated like 106:52:00. I need to incert the : colons and add the zero. I have tried
changing the format and it thinks it is a serial number, which it is not. Can anyone help with this. Either a formula or VBA!