Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Clearing scheduled work hours for weekends
I have set up an worksheet for employees that automatically populates two
rows, the day (eg. Wed) the date (e.g. 15). The first day and date are calculated from a mm/dd/yy entered by the employee. Successive day and dates are completed by simply adding 1 to the previous cell formula. What formula do I use to automatically populate a third row with a sheduled value of "7.5" for Monday - Friday and "0.0" for Saturday and Sunday"? e.g. DAY: Wed Thu Fri Sat Sun Mon Tue etc. DATE: 15 16 17 18 19 20 21 etc. SCHE: 7.5 7.5 7.5 0.0 0.0 7.5 7.5 etc. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find gaps in the hours scheduled to ensure shift coverage | Excel Worksheet Functions | |||
get hours between 2 dates subtracting the weekends | Excel Discussion (Misc queries) | |||
scheduled hours total | Excel Discussion (Misc queries) | |||
scheduled hours total | Excel Worksheet Functions | |||
equation that adds hours as scheduled. 11:00 to 5:00 +6hrs. res. | Excel Discussion (Misc queries) |