Rounding up time

Solved/Closed
josh07429 Posts 14 Registration date Friday June 23, 2017 Status Member Last seen November 20, 2017 - Updated on Jun 30, 2017 at 05:34 PM
 nickname missing - Jun 30, 2017 at 06:15 PM
Hi,

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.
Related:

1 response

nickname missing
Jun 30, 2017 at 06:15 PM
17:22:00 is PM not AM
1