I need an Excel File that will give me a total based on 2.45 for one hour and 1.23 for a half hour. Not sure what the best method to go about this would be. But I have a babysitter who works 9 hours a day and if she works a full 9 hours then she makes $22 for that day. However, she is an hourly employee so if she onlyl works for 4 hours then I need to calculate 4 hours of work. This is based on two weeks so a calendar may not be the best approach. I was thinking that I could add the whole total hours she works in a cell and then calculate all the cells for a total or have it do a running total.
1 Hour = $2.45
1/2 = $1.23