Please see sample attachment.
Please see sample attachment.
Are HRS remaining supposed to be allocated by % days in month?
For example, if July had 10 days and August had 10 days, would it be 50% split on hours?
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Yes, that is correct.
I had a play with this and attached is the result - not perfect but it works, but every month you would need to do a little extra work and modify the formulas a little. Anyway, it's a start!
DAYS & HOURS.xlsx
see the attached file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Siva, this works great except for one issue that I forgot to mention. The days remaining needs to calculate working days (not weekends).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks