Display Hours (1.5) instead of 1 Hrs 30 Mins

[KeyBerry]

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?

[Carley_Church]

Hi @KeyBerry , you can try this:

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

2. For the “Hours Work” column, use this formula:
   thisRow.Hours.ToMinutes()/60

[Christiaan_Huizer]

hi @Carley_Church , hi @KeyBerry

The simplest is this one:

toHours()

Cheers, Christiaan