Rounding up time [Solved/Closed]

Registration date
Friday June 23, 2017
Last seen
November 20, 2017

Im having a problem on rounding up time,

I've use =mround(A1,"1:00") it works fine on dates and time like this "5/2/2017 7:01 AM"

but when it comes to times that past 12pm im getting an error example is "5/2/2017 17:22:00 AM" I get #VALUE!

I need help how to roundup these dates with this numbers. I think mround only works to 1-12am/pm but if it goes to 13-24 it gives out an error.
See more 

1 reply

Best answer
Thank you
17:22:00 is PM not AM

Say "Thank you" 1

A few words of thanks would be greatly appreciated. Add comment

CCM 5735 users have said thank you to us this month