Excel 2007 : [SOLVED] mround function won't round up

[donkey1]

Hey guys/gals,

I'm using this =TIMEVALUE(HOUR(B2)&":"&MROUND(MINUTE(B2),1)) to round my times to the nearest minute but it won't round up.

For example 1:09:04 pm and 1:09:50 pm will both round to 1:09 pm.

I tried using =ROUND(B2*24/0.016666,0)*0.016666/24 and using the conversion but couldn't round to the nearest minute.

Any help would be greatly appreciated. TIA

[shg]

=mround(b2, "0:01")

[donkey1]

I love you. no homo