ExcelBanter - TIME KEEPING BY TENTHS

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - TIME KEEPING BY TENTHS (https://www.excelbanter.com/excel-worksheet-functions/190174-time-keeping-tenths.html)

Pam

TIME KEEPING BY TENTHS

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

Mike H

TIME KEEPING BY TENTHS

Multply your time by 24 and format as general

Mike

"Pam" wrote:

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

Lars-Åke Aspelin[_2_]

TIME KEEPING BY TENTHS

On Thu, 5 Jun 2008 07:20:11 -0700, Pam
wrote:

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

All times are GMT +1. The time now is 11:14 AM.