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" | Community
Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by imgrund

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

1 reply

imgrund
Adobe Employee
imgrundAdobe EmployeeAccepted solution
Adobe Employee
March 29, 2021

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
Level 3
March 29, 2021

Anthony,

You are always the smartest person in the room!

Joanne.