L Lars-Åke Aspelin Jun 6, 2008 #3 I need to make a formula for time keeping, such as 8:06 = 8:10 Click to expand... Try this: =TIME(HOUR(A1),MROUND(MINUTE(A1),10),0) and format the cell as t:mm Hope this helps. / Lars-Åke
I need to make a formula for time keeping, such as 8:06 = 8:10 Click to expand... Try this: =TIME(HOUR(A1),MROUND(MINUTE(A1),10),0) and format the cell as t:mm Hope this helps. / Lars-Åke
M molly parker Oct 11, 2010 #4 If you are using a calculator, divide the minute portion into 60. Source: http://www.calculatehours.com/excel-how-to/convert-hours-to-decimal.html
If you are using a calculator, divide the minute portion into 60. Source: http://www.calculatehours.com/excel-how-to/convert-hours-to-decimal.html
A alanglloyd Oct 12, 2010 #5 Source: http://www.calculatehours.com/excel-how-to/convert-hours-to-decimal.html Click to expand... That site has an error in stating how Excel calculates days, it says : "Excel calculates today’s date as the number of days that passed since January 1st 1900" It should be : "Excel calculates today’s date as the number of days that passed since December 31st 1899" But it is correct in saying that Jan 1 1900 is day 1. Alan Lloyd
Source: http://www.calculatehours.com/excel-how-to/convert-hours-to-decimal.html Click to expand... That site has an error in stating how Excel calculates days, it says : "Excel calculates today’s date as the number of days that passed since January 1st 1900" It should be : "Excel calculates today’s date as the number of days that passed since December 31st 1899" But it is correct in saying that Jan 1 1900 is day 1. Alan Lloyd