CODEWITHSUNDEEP
exceldatetimeexcel-formula
JanZitniak
JanZitniak

Reputation: 197

TIMEVALUE in Excel convert greater than 24 hours

I would like to convert text time into real time via TIMEVALUE function in Excel. Time up to 24:00 converts fine, for time greater than 24 hours it converts into hours but excluding 24, I already used custom format [h]:mm, please see my printscreen.

enter image description here

Upvotes: 4

Views: 6288

Answers (1)

user4039065
user4039065

Reputation:

It sounds like you are using the TIMEVALUE function for text-to-time conversion. Use the VALUE function instead and format as [hh]:mm.

enter image description here

If you want to convert in-place, then use the Data ribbon's Text-to-Columns command.

Upvotes: 3

Related Questions