Mike,
I think you are on the right path but I need some help still. I plugged in your formula and put in the current pay period start date of 7-21-13. The hours updated correctly, but when I advance the system time instead of adding 8.308 hours it subtracts the time. I attached the current spreadsheet with your formula in cell K29.
Bookmarks