G
Guest
Hi Everybody!
I’m a limousine chauffeur and I made a small spreadsheet to make the price
calculation faster but I have a problem. I have to collect money for the
service, gratuity, tax and if I have than for overtime. If I’m over the first
10 minutes I have to collect a full hour. I need help to calculate this. So
far I have in A10 - Type of payment Cash /Card . B10 – Pick-up Date MM/DD/YY
.. C10 – Pick-up Time HH:MM . D10 – Drop-off Date MM/DD/YY . E10 – Drop-off
Time HH:MM . F10 – Overtime Drop-off Time HH:MM . G10 – Hour charge $100.00 .
H10 – Gratuity 25% . I10 – Tax 10% . J10 – Hours
=IF(C10="","",IF(E10="","",IF(F10="",((D10+E10)-(B10+C10)),((((D10+E10)-(B10+C10))+((D10+F10)-(D10+E10)))))))
.. K10 – Service Charge =IF(J10="","",(((J10-INT(J10))*24)*G10)) . L10 –
Gratuity Charge =IF(K10="","",(K10*H10)) . M10 – Tax Charge
=IF(K10="","",((K10+L10)*I10)) N10 – Total =IF(K10="","",(SUM(K10:M10)))
O10 – Overtime =IF(F10="","",((D10+F10)-(D10+E10))) . Please help me.
I’m a limousine chauffeur and I made a small spreadsheet to make the price
calculation faster but I have a problem. I have to collect money for the
service, gratuity, tax and if I have than for overtime. If I’m over the first
10 minutes I have to collect a full hour. I need help to calculate this. So
far I have in A10 - Type of payment Cash /Card . B10 – Pick-up Date MM/DD/YY
.. C10 – Pick-up Time HH:MM . D10 – Drop-off Date MM/DD/YY . E10 – Drop-off
Time HH:MM . F10 – Overtime Drop-off Time HH:MM . G10 – Hour charge $100.00 .
H10 – Gratuity 25% . I10 – Tax 10% . J10 – Hours
=IF(C10="","",IF(E10="","",IF(F10="",((D10+E10)-(B10+C10)),((((D10+E10)-(B10+C10))+((D10+F10)-(D10+E10)))))))
.. K10 – Service Charge =IF(J10="","",(((J10-INT(J10))*24)*G10)) . L10 –
Gratuity Charge =IF(K10="","",(K10*H10)) . M10 – Tax Charge
=IF(K10="","",((K10+L10)*I10)) N10 – Total =IF(K10="","",(SUM(K10:M10)))
O10 – Overtime =IF(F10="","",((D10+F10)-(D10+E10))) . Please help me.