Hi I have
This is probably really simple but I am not fab on formula.
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!