Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
converting time to decimalPosted 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 decimalPosted 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.
Re: converting time to decimalPosted by Adam S. on January 31, 2002 3:08 PM
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
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.