Ignoring 'seconds' when referencing a duration type column

I’ve got a duration column titled [NPH] which ignores seconds and I’ve got a Long Text column called [NPH Reason].

In [NPH Reason] in the ‘Initial Value’ setting, I have used [NPH] so the duration is there for when I need to add some text (so I don’t have to come out of the editing page to view the NPH if you understand).

In [NPH Reason], the duration is formatted as 00:00:00, hope can I get the to ignore the seconds so it only shows Hours and Minutes?

I’ve looked and I can’t find anything about it. Probably something to do with the column types being conflicting.

TEXT()

1 Like