Formula To Round Date Time To Decimal Minutes

[mrprofit]

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

[bakerman]

Nearest decimal minute.

=CEILING(R2,1/1440)

Nearest 2decimal minute

=CEILING(R2,1/720)