TIME KEEPING BY TENTHS

[Pam]

I need to make a formula for time keeping, such as 8:06 = 8:10

 

[Mike H]

Multply your time by 24 and format as general

Mike

 

[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

 

[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

 

[alanglloyd]

Source:  

http://www.calculatehours.com/excel-how-to/convert-hours-to-decimal.html

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