Formula To Round Date Time To Decimal Minutes

2014/04/21 08:00:05 = 41751.33333

How to convert it to nearest decimal minute? i used =CEILING(R2,1/(24*60*60)) is this the correct formula? and how to convert it to nearest 2minute decimal minute. 2014/04/21 08:02:00

Nearest decimal minute.

Code:

---

=CEILING(R2,1/1440)

---

Nearest 2decimal minute

Code:

---

=CEILING(R2,1/720)

---