Does anyone know if there is text mode out there to remove the word "days" in the duration column of a view? Example: Result would be "5" instead of "5 Days"

[AnthonyIm · Accepted solution]

Hi Joanne!

Duration is in minutes, so you have to do it based on the number of hours you have for a typical day. For us, we have 8 hour days so my text mode is...

displayname=Duration (Just Number)

textmode=true

valueexpression={durationMinutes}/480

valueformat=string

[JoanneDuckman]

Anthony,

You are always the smartest person in the room!

Joanne.