Report

Rounding up time [Solved]

Ask a question josh07429 15Posts Friday June 23, 2017Registration date July 7, 2017 Last seen - Last answered on Jun 30, 2017 at 06:15 PM by nickname missing
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.
Helpful
+1
plus moins
17:22:00 is PM not AM
Was this answer helpful?  
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!