CODEWITHSUNDEEP
exceltimeexcel-formula
West
West

Reputation: 2570

Convert minutes and seconds to hours, minutes and seconds in Excel

I have the value 123:04 in an Excel cell and it currently stands for 123 minutes and 4 seconds.How can I convert this value to hours minutes and seconds?

Upvotes: 1

Views: 1967

Answers (1)

Scott Craner
Scott Craner

Reputation: 152650

If simply changing the format to [hh]:mm:ss does not change to the correct format, then it would need to be in [hh]:mm format or it is a string. Use this:

=A1/60

Then format the result as [hh]:mm:ss

enter image description here

Upvotes: 3

Related Questions