Forum Discussion
Converting a 4 digit number to time
I have just changed to 365 from an older version of Excel. I have a large amount of data that I import from CSV, which has times recorded as 4 digit numbers. I need to display it as a time (ie 1330 t...
Hi!
Using Excel 365 allows me to insert the following function:
=TIMEVALUE(TEXT(A1,"00\:00"))
You should just then adjust the cell format to hours. Change cell A1 to your actual 4 digit reference cell!
MAngosto Thank you, that worked on the data, but it all goes sideways, if I try to copy and paste it somewhere else and my screen fills up with #ref
Any formula could give such effect. To avoid it paste as values.
Alternatively you may Ctrl+1 on the cell(s) and apply custom format
With that simple paste, not paste as value.
Assuming you perform no calculations with such values.
