Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
72
Views
Topic starter
I have a data set that I work with that exports to excel with a strange time format that excel doesn’t recognize. In one cell it will show time as, “7 hours, 11 minutes”, “14 hours, 5 minutes”, etc. I usually just go through and change these to “7:11”, “14:05”, etc. by hand. Is there an easier way to get excel to convert this format to the workable format that I can use for the reports I’m putting together? Any suggestions would be appreciated. Thank you!
Posted : 26/03/2022 8:58 pm
Hi Ichiha,
Welcome to our forum!
You can use this formula where your text is in cell A1:
=TIMEVALUE(SUBSTITUTE(SUBSTITUTE(A1," hours, ",":")," minutes",""))
Then apply the Time format to the cell.
Mynda
Posted : 27/03/2022 7:54 am
