Solved Rounding up time instead of number

May 26, 2011 at 12:06:10
Specs: Windows 7
I need to roundup a block of time to the near 10 min increments.

ex. cell F4 has 8:43 AM cell G4 has 9:16 AM using formula =TEXT(G4-F4,"h:mm") I get 0:33 in cell H4 now i need to roundup this :33 min to the nearest 10 in cell I4 but not sure how to write the formula.

Please help :)


See More: Rounding up time instead of number

Report •


#1
May 26, 2011 at 12:46:12
Try this:

=MROUND(H5,"0:10")

If you get an error message, then install the Analysis Tool Pack add-in.

Sorry, =MROUND() only rounds Down.


MIKE

http://www.skeptic.com/


Report •

#2
May 26, 2011 at 12:57:35
Thanks for the thought :)

Report •

#3
May 26, 2011 at 13:01:01
✔ Best Answer
OK,

Try this one:

=CEILING(H4,10/1440)

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
May 26, 2011 at 13:19:53
PERFECT - THANKS SO MUCH :)

Report •


Ask Question