Posted by Teri Fieds on January 07, 2002 5:21 PM
Hi, I need help with a running total. I have a spreadsheet with hours worked and overtime hours (something like this)
Name: Fields, Total OT Hours: 170, Current OT Hours: 8, New Total OT Hour: 178. I need a macro (I think) to save the total hours(178) and move it the the total OT column and then allow me to add additional hours to the current hours cell. A sort of running or cummulative total, can this be done? Maybe my approach is wrong. I wonder if anyone has ever had a problem like this. Thanks in advance.