Display Hours (1.5) instead of 1 Hrs 30 Mins

So … I’m trying to show the duration in hours, like this: 1.5 … instead of 1 Hrs 30 Mins.

I feel like such a dolt … I’ve went through all the math things and the format thing … what am I missing?

Hi @KeyBerry , you can try this:

  1. Have the “Hours” column be a calculated duration.

  2. For the “Hours Work” column, use this formula:

hi @Carley_Church , hi @KeyBerry

The simplest is this one:


Cheers, Christiaan


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.