How to convert time to minutes in excel? There are 1,440 minutes in a day, to get the minute number from a TIME value is to multiply it by the number 1440.įormula #3, using HOUR, MINUTE and SECOND function Convert Time to Minutes in Excel Formula #1, using multiplication formula The results remain the same as the previous two ways. To get the hour value from the minute value divided by 60 (number of minutes in one hour) and to get an hour value from the second value divided by 3600 (number of seconds in one hour). The TIME value consists of hour, minute and second value. To get the HOUR number from the time value, why not just use the HOUR function? Why do the MINUTE function and SECOND function also apply? The third way to use the excel HOUR function, excel MINUTE function and excel SECOND function, but still involves mathematical formulas (multiplication or division).įor a more detailed explanation about Excel CONVERT function, please read “ How to Use the Excel CONVERT Function“ Formula #3, using HOUR, MINUTE and SECOND function

The second way is using the excel CONVERT function, an excel function to convert from and to various units of measurement. The first way to convert a time value to hours, minutes or seconds number is to use the multiplication formula. Formula #3, using HOUR, MINUTE and SECOND functionĮxcel stores TIME values in decimal numbers, but in day unit.Formula #1, using multiplication formula.

Excel time zone conversion