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.
imgrund
imgrundAccepted solution
Employee
Mar 29, 2021 6:05 PM UTC

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

2 replies

imgrund
imgrundAccepted solution
Employee
Mar 29, 2021 6:05 PM UTC

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

Translate
JoanneDuckman
Level 3
Mar 29, 2021 6:08 PM UTC

Anthony,

You are always the smartest person in the room!

Joanne.

Translate