Duration type of column but just minutes + seconds

[MARIO_BOGANTES_]

Hello Community!

I´m trying to prototype an app for documenting the duration of some behavioural tests, that usually take less than 5 minutes. I would like the Duration column to record and display only minutes : seconds, and if possible ± buttons such as the ones on the the number type columns.

Is there any way to do this?

Thanks in advance

[Suvrutt_Gurjar]

You may wish to explore the workaround below. It sounds that the needful can be done with the help of two columns.

Create a number type column called say [SetDuration] with Maximum value as 300 ( corresponding to 5 minutes), minimum value 0 , increment decrement value 1

Create a duration type column say [BehaviorTestDuration] with an expression something like

TIME(“00:”&(“0”&FLOOR([SetDuration]/60),&":"&RIGHT(“0”&( MOD([SetDuration],60)),2)))-“00:00:00”

The user can set the duration through the [SetDuration] number type column in seconds. The expression in [BehaviorTestDuration] converts the seconds set in [SetDurtion] to a “mm:ss” duration value.

It will look like something below

Edit: Made the duration expression more compact.