Formula hours to decimal

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

Hi Marco,

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


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?

1 Like

Thank you very much