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
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.
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:
- Rounding up time
- Popcorn time download - Download - Movies, series and TV
- Facebook id verification time - Guide
- Ocarina of time rom - Download - Action and adventure
- How to change time in whatsapp - Guide
- Up time in phone - Guide
