Formula field - How to calculate "Actual time" with a number

[Richard_Sather]

Hi @Michał_Ejmont , have a look at no.8 here:

12 Formulas to get you started with the new Advanced Editor

Hi everyone! I hope you are all excited about the recent roll out of the Advanced Editor for Formula fields as I recently announced here. That post includes a video where I had the chance to showcase various use cases, so I thought I’d create this post to share more details on how I built them, which will hopefully inspire you while you try out the Advanced Editor for Formula fields (rolling out on Business and Enterprise tiers). 1. Task Duration: Prerequisites: Start & Due …

If you divide actual time by 60 it will convert it to a number in hours which you can then multiply by your rate field.