levinberg_e
New Member
- Joined
- Apr 3, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi there,
When exporting data from a time logging software some columns are outputted as text containing times in HH:mm format ,
I want to convert these columns to a time format so that excel recognizes them as time and not text , however this does not work.
Even if I format these cells as custom time format HH:mm - the plain text still appears,
when I then try to change the cells to HH:mm:ss then the seconds do not appear - so I understand that excel has not recognized this as a time value?
any help on the simplest solution?
many thanks
When exporting data from a time logging software some columns are outputted as text containing times in HH:mm format ,
I want to convert these columns to a time format so that excel recognizes them as time and not text , however this does not work.
Even if I format these cells as custom time format HH:mm - the plain text still appears,
when I then try to change the cells to HH:mm:ss then the seconds do not appear - so I understand that excel has not recognized this as a time value?
any help on the simplest solution?
many thanks