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,

good luck