MS Excel : How to Convert Time into Hours, Minutes & Seconds

Microsoft Excel comes with many useful formulas, one of them is conversion of time into hours, minutes and seconds, so in this article I will shows you how to convert 24 hours or 12 hours format time into minutes and seconds, just follow the steps below.

1.      For Hours: Type “=” in blank cell, select time and insert *24 and hit “Enter” for example “=C6*24”

2.       For Minutes  =C6*(24*60)

3.       For Seconds =C6*(24*60*60)

Watch video tutorial… Please like, share & subscribe