How to Convert Time to Hours, Minutes and Seconds in Excel - Office 365

Excel stores times as decimal numbers, you can easily convert time to hours, minutes and seconds. You can convert time by using arithmetic calculations or Excel time functions such as HOUR, MINUTE and SECOND. You can also use the CONVERT function to convert time to hours, minutes and seconds.

To download example Excel file please click on the link below

[syedkhaleelbasha]

How to convert it in the reverse. In sheet1 D12 which is 10.5 i want to convert it to 10:30:00 how to do it

[jamesmyrthong]

Thank You so much for this tutorial. It's straight to the point. Well explained🙏🙏🙏🙏

[modalize]

What about converting 37845 seconds into 10:30:45?

[MushtaqAhmad-vytc]

I tried alot but in my laptop not converted.what is reason? Is it due to general?

[kakularsrikanth]

hi how to convert "2 days 23 hours 59 minutes " into HH:MM

[msrohith]

How to convert minutes into an hour minutes (ex : 90 mins into 1h.60mins)