Spreading hours out over weeks

myrtle67204

New Member
Joined
Feb 20, 2019
Messages
1
I have employees who only work 1560 hours per year. I want to create a spreadsheet for planning. row 4 will be what hours they actually worked. row 5 they will fill out for future planned hours for projects we know they will have. row 7 I have set up as an IF row. see the example in column M

My problem is I want row 8 to be an average of what they have left available to work per week. for example if its Feb 20 their total hours of planned and actual work is 246 (f6) there are 45 week left in the year 1560 max hour-246 hours already counted for. it means they can average 24.3 hours per week the rest of the year. but we know the week of Feb 24 they have 50 hours planned so I would want that to drop down to the average per week for planning purposes, like a place holder.

The spreadsheet increases per week all the way out to Dec 31 2019.

My head is exploding just thinking about it.


 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
3,576
.
For future consideration, post a workbook example with existing data sample and a sample of the expected outcome.

Images are too small to interpret ... and the FORUM volunteers do not have the time to re-create a worksheet.

Thanks.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,911
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top