Solved: Entry duration feature? - Page 2

Aurelien · 01-14-2021 01:23 AM

Hi all,

I’m looking for a way to type duration without having to type “00:43:00” for example, for 43 minutes.
I see there is a pickup feature for date, using a calendar, is there something similar for duration ?

If no, I will submit a request for it.

Many thanks in advance for your help.

Cheers !

Aurélien

Suvrutt_Gurjar

In that case, please explore if the following workaround helps.

The workaround requires two columns - one for time and one for duration. The workaround uses time picker ( needs to be set in 24 hours format though without AM/PM)

Column 1 called say [Set Time] of type Time with the show_if expression as CONTEXT(“ViewType”)=“Form”
Display Name of this column " Set Duration"
Column 2 ( Either real or VC) of type Duration called say [Set Duration] with show_if expression as
CONTEXT(“ViewType”) <>“Form”
Display Name of this column " Set Duration"

The app formula for the column 2 will be

[Set Time] - “00:00:00”

View solution in original post

Suvrutt_Gurjar

Thank you for the update. Good to know it works the way you wish.

However as I mentioned, the above workaround requires the time setting of the device in 24 hours format. If user fails to do that , the user will be unable to set duration beyond 12 hours and it will also display AM/ PM notation.

So . another workaround may be to have two number type columns in slider (range setting) mode.
Hours setting from 00 to 23 and minutes and seconds setting in 00 to 59 range with the increment /decrement steps of 1

If these settings are in slider mode , the user will find it convenient to easily set hours and minutes ( and seconds, if required)

The third duration column can have an expression as below that converts the number settings into duration.

TIME(CONCATENATE([Set Hours],":",[Set Minutes]))-“00:00:00”

In the screenshot below, the SetDuration V is the computed duration column based on the two number settings columns above.

View solution in original post