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
|
No comments:
Post a Comment