Skip to main content

Hi I have

This is probably really simple but I am not fab on formula.

I have

column 1 that is hourly rate (£)

column 2 the task (looks up sheet 1) (text)

column 3 Duration (looks up Time recorded via look up on Sheet 1) (Hour & mins)

column 4 Budget for the task (looks up sheet 1) ((£)

column 5 Final costs


Column 5 I cannot get the formula right. It seems to use the day rate and multiply’s the mins so day rate of £265 worked 20 mins is totalling 318, 000, 00…Can a kind soul please help me? Thank you!

Welcome to the community, @Katie_McHugh! :grinning_face_with_big_eyes: When referencing a duration field, Airtable is going to give you a value representing the number of seconds for that duration. To make this work with an hourly rate, divide that value by 3600 (the number of seconds in an hour) before multiplying with the rate. Something like this:


{Hourly Rate} * (Duration / 3600)

Welcome to the community, @Katie_McHugh! :grinning_face_with_big_eyes: When referencing a duration field, Airtable is going to give you a value representing the number of seconds for that duration. To make this work with an hourly rate, divide that value by 3600 (the number of seconds in an hour) before multiplying with the rate. Something like this:


{Hourly Rate} * (Duration / 3600)

Oh Justin, thanks ever so much, much appreciated, this is brilliant – life saver.

Reply


Terms & Conditions