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
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.
Nearest 2decimal minuteCode:=CEILING(R2,1/1440)
Code:=CEILING(R2,1/720)
Posting Permissions
Reply With Quote
Bookmarks