Archive of Mr Excel Message Board


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

converting time to decimal

Posted by Larry on January 31, 2002 3:03 PM
In Microsoft Excel! how can I convert a period of time such as 00:45:45 h:m:s to decimal 45.75 mins.? To allow this number to be used in other calculations

Check out our Excel Resources

Re: converting time to decimal

Posted by Barrie Davidson on January 31, 2002 3:06 PM

Multiply your cell with the time by 24. For example, if A1 = 00:45:45 then =A1*24 will convert that number to 45.75.

Regards,
BarrieBarrie Davidson


Re: converting time to decimal

Posted by Adam S. on January 31, 2002 3:08 PM
Hiya.

Time values are actually decimals already (in terms of a fraction of a day). So 45 minutes and 45 seconds is actually .031771 or so (just format your current 00:45:45 value as a number to check). If you mulitply that value by 60*24 that should convert the value of 00:45:45 (time format) to 45.75 (in a number format).

Hope that helps
Adam S.


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.