Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula help request please

Topic Labels: Formulas
102 2
Showing results for 
Search instead for 
Did you mean: 

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!

2 Replies 2

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.