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 :)

~~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

Thanks for the thought :)

PERFECT - THANKS SO MUCH :)

Ask Your Question

Weekly Poll