l o a d i n g

Excell formulas with reoccurring function

May 3, 2024 - Junior

$736.00 Fixed

Hi, We have a relatively straight foward issue, we use a spreadsheet as a total hour tracker for some of our employees as they need to maintain 38 hours per week, but will do different each week, so we just keep a running balance the formula just takes the total balance from the last week, adds on total hours worked this week, etc =O166-[@[Total Hours]]+38 Now its an absolute mission to add new employees or additional weeks into this chart, I would like a button (Marco?) at the top where we could insert a new employee and where we can add additional weeks into the spreadsheet. See attached for what we are using - my formula that I am using could probably be made better. if we could have a running total somewhere that we could pull data off that would be nice - as currently we just look at each week.
  • Proposal: 0
  • 40 days
AuthorImg
Gautami Embranthiri Inactive
,
Member since
Mar 9, 2024
Total Job
3