Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

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

Avatar

Level 4
 
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

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

Avatar

Level 4

Anthony,

You are always the smartest person in the room!

Joanne.