D
Dena J
I have a spreadsheet that tells me how many hours are worked at our
production centers and I would like to find out if there is a way that I can
use the data from each week to give me the projected hours worked per month.
The information that I have available to me is the hours budgeted to each
location, the hours worked in each week starting from the first of the month
and ending on the last day of the month (Mar.1 thru Mar. 31), the actual
hours worked are added so the managers can tell how many total they have used
for the month so they do not go over but I want to give them an idea of how
many they will use if they continue using the same hours everyweek. I am
thinking I will have to use a formula that will also include how many working
days are in the month. If anyone is not confused with this please help me!!!
production centers and I would like to find out if there is a way that I can
use the data from each week to give me the projected hours worked per month.
The information that I have available to me is the hours budgeted to each
location, the hours worked in each week starting from the first of the month
and ending on the last day of the month (Mar.1 thru Mar. 31), the actual
hours worked are added so the managers can tell how many total they have used
for the month so they do not go over but I want to give them an idea of how
many they will use if they continue using the same hours everyweek. I am
thinking I will have to use a formula that will also include how many working
days are in the month. If anyone is not confused with this please help me!!!