P
Pam
I need to make a formula for time keeping, such as 8:06 = 8:10
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Multply your time by 24 and format as general
Mike
Mike
L
Lars-Åke Aspelin
I need to make a formula for time keeping, such as 8:06 = 8:10
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
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
Source:
http://www.calculatehours.com/excel-how-to/convert-hours-to-decimal.html
A
alanglloyd
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