Hi Everybody!
Im 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 Im 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.

--
Many thanks for your help in advance. Have a wonderful day and weekend!
Zsolt