App for time tracking

Hello,

I have a timesheet app and i am wondering if i can limit the input on the minutes to be ending by 0s or 5s. What I mean is that instead of an employée saying he started at 08:02 I want that it is limited to 08:00 or 08:05. I already disabled the seconds. Thanks in advance

hello i tried to apply this formula in my app but i get an error parameter 1 of function minute is of the wring type. From what i see it is the format of my column but i do not understand where i am wrong.

You won’t be able to us ethat perfectly… it’s for a duration column… you will need to ADAPT it to fit your needs.

@LeventK Can you help out, I haven;t done this in awhile!

@Andrian_Andreev
Assuming that your column type is TIME, try with this expression:

IF(
	MOD(MINUTE([TIME] - "00:00:00"),5) = 0,[TIME],
	IF(
		(CEILING(MINUTE([TIME] - "00:00:00") / 5) * 5) + 5 = 60,
		TIME(HOUR([TIME] - "00:00:00") + 1 & ":00"),
		TIME(HOUR([TIME] - "00:00:00") & ":" & ((CEILING(MINUTE([TIME] - "00:00:00") / 5) * 5) + 5))
	)
)

2 Likes

@Andrian_Andreev
You can also implement and use the above expression as an initial value of your TIME column:

IF(
	MOD(MINUTE(TIMENOW() - "00:00:00"),5) = 0,[TIME],
	IF(
		(CEILING(MINUTE(TIMENOW() - "00:00:00") / 5) * 5) + 5 = 60,
		TIME(HOUR(TIMENOW() - "00:00:00") + 1 & ":00"),
		TIME(HOUR(TIMENOW() - "00:00:00") & ":" & ((CEILING(MINUTE(TIMENOW() - "00:00:00") / 5) * 5) + 5))
	)
)
3 Likes