basically I need to convert times into the nearest 30min interval and based a mintue given by the user it allows the person to be late by that minute or leave early by that minute.
I will try to explain below:
IN RND is rounding back to the nearest 30min interval
if after that given min then it will round to the next
OUT RND is forward to the nearest 30min interval if within
a given min time before that 30 min interval.
if before that given min time then it will round back
to the earlier 30 min interval.
I have an example below for rounding given the
IN RND & OUT ROUND is 5mins :
The next example is of the data and in RED is what
I want a button to calculate.
The IN and OUT is for each ID for each day.