I've attached the file for you guys to view.
It will be much easier if you can view the spreadsheet from there.
At the bottom right of the spread sheet.
You will notice these fields
Total Time Worked Hours : Min
(Incl Leave & Adjustments) 144 : 45
- Contract Hours 145 : 00
Balance CR 0 :15
Now the total contact ours is just standardized hours per month. Now As you can see there in the "Balance" field. I thas a credit of 15 minutes. When in actual fact it should be a debit (DR) of 15 minutes.
If someone could check on my formula in that field to let me know if I've got anything wrong. It should be showing "DR 0:15" not CR.
If anyone can help me out here. I'll be forever in your debt. Been trying so long to work this out
Thanks (See attached file "Excel File.xlsx")
Jason
Bookmarks