convert time to number
Posted by mike k on August 30, 2001 11:59 AM
How can I convert a time such as 16:37:00(16 min 37 sec) to 17 or to 16.62?
Posted by IML on August 30, 2001 12:08 PM
Assuming your time is A1,
=A1*24
or
=ROUND(A1*24,0)
good luck
Posted by mike k on August 30, 2001 11:59 AM
How can I convert a time such as 16:37:00(16 min 37 sec) to 17 or to 16.62?
Posted by IML on August 30, 2001 12:08 PM
Assuming your time is A1,
=A1*24
or
=ROUND(A1*24,0)
good luck
