Solved: In Duration - Remove hours, I only want to see min... - Page 2

pallavharia · 04-23-2023 03:01 AM

I'm building a "recipe app" for coffee.

I want to enter the "time/duration" at particular stages

For example : at 1 min 40 secs (01:40) I did X task , at 5 min 35 secs (05:35) id Y task.

Currently instead of "01:40" I can only enter "00:01:40"

Can anyone help me out.

And is there a better way of entering time intervals than typing?

WillowMobileSys

First, you cannot avoid having the Hours component.

@pallavharia wrote:

And is there a better way of entering time intervals than typing?

Unfortunately, not better than typing.

What you could do is have two fields. One for user input, the other is the input value converted to Duration - if needed. On the user input, implement validation to require them to enter the value in the format "mm:ss". Then set the Duration column with an expression like - "000:" & [User Input]

View solution in original post

In Duration - Remove hours, I only want to see minutes and seconds (mm:ss)