We can round to very specific times using a script. For example:
round ("9:00am - 9:30am = 9:30am");
This would round any punch between 9:00am and 9:30am to 9:30am.
Note: Be advised that when using this script it will work only if the "=" time falls on the start time (9:00am), anywhere between the start time and the end time (for example 9:02am, or 9:29am), or on the end time (9:30am) you cannot do it for a time outside of these for example:
round ("9:00am - 9:29am = 9:30am");
Since "= 9:30am" does not fall on either the start time or the end time or any time in between it will not work.
| |