Round Date/Time to closest minute

[User79]

Hello,

Is there a simple way to round a date/time to the nearest Minute ?

Example :  22/03/2013 10:23:35 rounded to 22/03/2013 10:24:00

                 22/03/2013 10:23:29 rounded to 22/03/2013 10:23:00

I could juste compare the seconds to 30 and round to Minute or Minute+1 but I would have to manage the change of day/month/year

Thanks,

User

[ben64 · Accepted solution]

---

@User79 wrote:

Hello,

Is there a simple way to round a date/time to the nearest Minute ?

Example :  22/03/2013 10:23:35 rounded to 22/03/2013 10:24:00

                 22/03/2013 10:23:29 rounded to 22/03/2013 10:23:00

I could juste compare the seconds to 30 and round to Minute or Minute+1 but I would have to manage the change of day/month/year

Thanks,

User

---

Here is a way to do it.

Ben64

[User79]

Hi Ben64,

Sorry for the delay. thanks for the accurate and quick answer !

Regards,

User