Hi all,
I am trying to create a calculation in my spreadsheet which takes various time entries and calculates how many half days I need to charge my customer.
So... currently I have:
Hours required on site in cell D32
Inbound travel time in cell D35
Outbound travel time in cell D36
Site Availability in E11
The labour times are all SUM'd in cell D39 to give a total labour time and then in cell D42 I am using the formula below to round the labour requirement to the nearest half day (based on the site availability hours) for pricing
=CEILING(D39/E11,0.5)
This is working perfectly, but I now need to adjust this slighty and I am struggling to work out how to do it.
I need to take the hours required on site (D32) against the site availability hours (E11) to equate how many site days are required. I then need to include the calculation of the travel time to establish whether the addition of these hours need to increase the 'days' required to charge or if the total time will still fall within the days required for site labour.
I dont feel like I have explained this very well, but I am becoming very bamboozled so any help would be greatly received!
I am trying to create a calculation in my spreadsheet which takes various time entries and calculates how many half days I need to charge my customer.
So... currently I have:
Hours required on site in cell D32
Inbound travel time in cell D35
Outbound travel time in cell D36
Site Availability in E11
The labour times are all SUM'd in cell D39 to give a total labour time and then in cell D42 I am using the formula below to round the labour requirement to the nearest half day (based on the site availability hours) for pricing
=CEILING(D39/E11,0.5)
This is working perfectly, but I now need to adjust this slighty and I am struggling to work out how to do it.
I need to take the hours required on site (D32) against the site availability hours (E11) to equate how many site days are required. I then need to include the calculation of the travel time to establish whether the addition of these hours need to increase the 'days' required to charge or if the total time will still fall within the days required for site labour.
I dont feel like I have explained this very well, but I am becoming very bamboozled so any help would be greatly received!