Formula to calculate minutes by hourly rate to create total

[CJMac (Coni)]

Hello, I need assistance in creating the formula to calculate the total minutes by the hourly rate to get the total billed. The formula I’m using just doesn’t work and I have tried several. I even tried ai formula and it still doesn’t work. Please let me know what I am doing wrong. Thanks.

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

Hi @CJMac,

Try:

ROUND(SUM(ROUNDDOWN(SUBSTITUTE(HOURS_DIFF({End Time},{Start Time}),":","."),0),DIVIDE(SUBSTITUTE(HOURS_DIFF({End Time},{Start Time}),":",".")-ROUNDDOWN(SUBSTITUTE(HOURS_DIFF({End Time},{Start Time}),":","."),0),0.6)),2)

It will give you a decimal number of hours that you can then multiply by your hourly rate.

–
Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

• Create formulas without using the Formula column (and avoid its limitations)
• Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
• In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

[CJMac (Coni)]

Very helpful! Thank you so much.