How can I insert a colon into a column of existing numbers
If 1845 is 00:18:45 (18 minutes, 45 seconds):
=--TEXT(A1,"00\:00\:00")
If 1845 is 18:45:00 (18 hours, 45 minutes):
=--TEXT(A1,"00\:00\:\0\0")
Format each as time.
jcmonzon wrote:
I have two columns of numbers which are suppose to represent times, but were
entered as a number format. Example: "1845" instead of 18:45. I'm looking
for a way to insert the colon into the numbers so I can do a time calculation.
Note: formating the columns as Time does not work because of the way Excel
handles date & time in a serial manner.
Thanks
--
Dave Peterson
|