Friday, 13 April 2018

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

MS Excel : How to Convert Time into Hours, Minutes & Seconds, time convert in ms excel, convert hour into minutes & seconds, convert hours to seconds, convert hours to minutes, how to convert time into hours minutes & seconds, excel 2007, excel 2010, excel 2016, Microsoft Excel, Excel tips & tricks, 2018 tips, time converter, date converter, time hours minute seconds formula, excel formula, convert 24 hours into 12 hours, 12 hours to 24 hours time converter, 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