MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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