Formula hours to decimal

[MAS (Marco)]

can somebody help me with the formula?
i need Total hours in decimal

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Hi Marco,

If you have 2 hour columns and want to get the difference in hours, you can use:

HOURS_DIFF({Startzeit},{Endzeit})

To convert it to a decimal, use:

LEFT(HOURS_DIFF({Startzeit},{Endzeit}),2)+ + RIGHT(HOURS_DIFF({Startzeit},{Endzeit}),2)/60

 
 

---

Curious to know how that same formula would look in the Advanced Formula Booster, the 3rd party app that makes it so easy to write formulas?

[MAS (Marco)]

Thank you very much