General discussion
August 1, 2005 at 12:28 PM
sweta.panchal

If statment

by sweta.panchal . Updated 21 years, 2 months ago

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.

This discussion is locked

All Comments