TIME KEEPING BY TENTHS

  • Thread starter Thread starter Pam
  • Start date Start date
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
 
Back
Top