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