Determining if my IF statements are correct. Formula not outputting the data correctly

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

Originally Posted by FDibbins

Hi and welcome to the forum

Maybe add =?
=IF(BalanceHrs<=0,"DR","CR")

You FDibbins sir are the greatest.

Thank you so much.