Home Insurance | Remortgages | Mortgage Calculator | Credit Cards | Loans
need help with MS Excel 2000 [Archive] - ZGeek

PDA

View Full Version : need help with MS Excel 2000


ppuchi
18-03-2004, 06:57 PM
hi there, i got some trouble in solving some problem in Excel2000..hopefully someone can help me out..here it is..

You have taken a part-time job as manager of the Happy Hamburger Stand.he stand is open from 6AM--3AM,and employees work all different schedules.Because of a booming business at dinnertime,you decide to pay $10.00 per hour for any time worked betweenn the hours of 5PM and 8PM, the other hours,employees are paid $8.00 per hour.
Your work sheet should have "check-in Time" and "Check-out Time" as inputs.Find out the number of hours an empolyee worked and the amount of money he/she should be paid.

well...i've been desperatedly seeking for the solutions....and I'll sosososo appreciate it if you help me out with it!

MisterBishi
18-03-2004, 09:58 PM
You need to use =IF in your formulae, but it would be a sin to do your homework for you so you should ask the paperclip about the syntax and stuff.