Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for roster costing Please
Thanks for reading, I have a simple roster setup in Excel 2003 and would like
a formula to cost it, I have split the window so on one side I have the roster I can print off easy with simple sums, on the other side I would like to cost. Both sides are Mon - Sun. I have placed payrates for different times in unused cells, the hours vary from 6 Am - 9 Pm but the cutoff is 6 Pm, 6 to 6 is day rate, after 6 depends on the day as to what rate. I would like the formula to calculate automatically from the roster side if the worker worked and to calculate the pay wether they finish early or finish later. I am able to input the payrate in the formula, so any help would be much appreciated. Day-$10.00 1.5-$15.00 2-$20.00 MON TUE START 11.00 START 9.00 BREAK 0.50 BREAK 0.50 FINISH 19.00 FINISH 16.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Total costing | Excel Worksheet Functions | |||
Need formula to pull for class roster | New Users to Excel | |||
costing | Excel Discussion (Misc queries) | |||
Product costing | Excel Worksheet Functions | |||
Product costing | Excel Worksheet Functions |