Hi There,
Have a question whether this is possible with a formula or I will need to use a VBA solution.
I have two columns on a time sheet, column A is regular work hours column B is Overtime hours.
I have trying to find a way that when the sum of column A hits 40.00 to start accruing hours in Column B
Column A Column B 8.21 - 8.14 - 8.58 - 8.34 - 6.73 1.52 40.00 1.52
Any Ideas? I can't seem to figure out anything that wouldn't be a nightmare of a formula.
Thanks!
Bookmarks