I need a formula to calculate the below in excel , there are 6 different headings; Labour rate, hours, travel, materials, 15 min allowance and value, below are the steps to the final value:
1.Addition of hours and travel to create the sum total e.g. 2.3 + 1.7 = 4
2.Multiple the sum total 4 by the labour rate e.g. £17.33 so 17.33 x 4 = £69.32
3. Add materials to this sum total so £69.32 + 15 = £84.32
4. Output the total to the value column
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.