I have everything in my Excel Sheet Correct EXCEPT when they take PTO it doesn't calculate accurately. Help. Please see attached Sheet.
I have everything in my Excel Sheet Correct EXCEPT when they take PTO it doesn't calculate accurately. Help. Please see attached Sheet.
Not sure what you are after... but I assume it's Balance.
Try below in E4 and copy down.
Formula:Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Try this. Rolling balance = Prior Balance + Accrued PTO - Used PTO
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks