Hi @HS-ACG , it should work if you insert +0 after Actual time and then divide by 60 to convert the minutes to hours. Then divide by 8 to get your ‘consulting days’.
I’ve documented several such ‘hacks’ here:
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 Like