Rounding up numbers in hh:mm:ss format

  • Thread starter Thread starter Thorbjorn Sundboe
  • Start date Start date
T

Thorbjorn Sundboe

I have a columnn of numbers stored in the hh:mm:ss (custom) format. I need
to round up all cells that have ss>0 an add 1 to mm; in other words all
cells with seconds should be rounded up to the next minute. How can I do
that?

Cheers, Thorbjorn
 
Back
Top