Previous Topic Next Topic

Rounding up time

Solved/Closed
josh07429 Posts 16 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 reply

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

Similar discussions

We can't review this decision
03425911668 -
HelpiOS -

5 responses
The system time is invalid
LeonardPromise -
Jules_St-Germain -

5 responses
Keyboard typing letters and numbers at the same time
Hottie -
Isebas -

37 responses
hello my account is disabled
Mohdsheraz -
HelpiOS -

1 response