Hello,
I need to round a time value, formatted as [hh]:mm:ss, up to the next minute, i.e. "02:08:11" up to "02:09:00", regardless of the "11" seconds being closer to "08" minutes. Any ideas...?
Thanks,
Frith
Hello,
I need to round a time value, formatted as [hh]:mm:ss, up to the next minute, i.e. "02:08:11" up to "02:09:00", regardless of the "11" seconds being closer to "08" minutes. Any ideas...?
Thanks,
Frith
If you have a time value in A1 you can round up to the next minute with this formula in B1
=CEILING(A1,"0:01")
Audere est facere
Thanks! That did it... Now back to other issues...
Frith
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks