Showing posts with label Convert Hours To Minutes in Excel. Show all posts
Showing posts with label Convert Hours To Minutes in Excel. Show all posts

Thursday, 17 January 2013

Convert Hours To Minutes in Excel


To Convert Hours to Minutes.

HOUR
MINUTE
FORMULA
1:00
60
=HOUR(A3)*60+MINUTE(A3)
1:02
62
=HOUR(A4)*60+MINUTE(A4)
1:04
64
=HOUR(A5)*60+MINUTE(A5)
1:06
66
=HOUR(A6)*60+MINUTE(A6)
    

TRICK :-To Convert Hours to Minutes.

HOUR
MINUTE
FORMULA
1:00
60
=A3*60*24
1:02
62
=A4*60*24
1:04
64
=A5*60*24
1:06
66
=A6*60*24