Formula help request please

Topic Labels: Formulas
505 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.