I would like to recommend a great book.
Excel Professional Development
The difinitive guide to developing applications using Excel
The project is a Time Clock and the development of the
time clock from code. Check it out at the Library first, just in case
it doesnt have what you need, or what your looking for.
--
William<"M"




"Zsolt Szabó" wrote:

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