M
MJKelly
Hi,
I have a column of time data in hh:mm format which I need to adjust.
I need the time to be changed to the nearest ten minutes so 13:01
would change to 13:00 and 13:05 would round up to 13:10. Can you
help? Would I need to try and if statement with Right(A1,1) etc?
Thanks,
Matt
I have a column of time data in hh:mm format which I need to adjust.
I need the time to be changed to the nearest ten minutes so 13:01
would change to 13:00 and 13:05 would round up to 13:10. Can you
help? Would I need to try and if statement with Right(A1,1) etc?
Thanks,
Matt