Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

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?

Check out our Excel Resources

Re: convert time to number

Posted by Eric on August 31, 2001 8:46 AM
After several hours trying last night and scouring this message board, I found the answer to the same question you had. I learned that Excel stores time in fraction of hours. If you want 16hours 37min (cell A) to show up as 16.62, use the formula =cellA*24. The same would work even if you are including seconds. Make sure to format cell B to "numbers" and leave 2 decimal places. Hope you don't spend as much time as I did figuring this simple thing out.

Eric


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.