I need a formula to calculate a difference of Time A (which contains total of scheduled week hours) minus Time B (which contains total of actual week hours).
For example if Scheduled hours were 40 hours and the actual hours worked for that shift was 44 hours. The result should show (-4).
I created if statement : =IF(A-B>0, A – B, B – A). this formula does show a result in 4 but I need it show in (-4). Is this possible?
I would appreciate your help.