I have a Result cell for carried forward annual leave (I14) but I need to be able to add in the ability to use/calculate minus entries. I'm unsure how to go about this! So any help is greatly appreciated.
The calc converts DAYS into HH:MM, based on location, and contract type. The user enters their CF balance into cell I10.
=IF(I2="REGION","",IF(AND(I2="NATIONAL",I6="FULL TIME"),(I10*7.4)/24,IF(AND(I2="NATIONAL",I6="PART TIME"),((S6/S10)*I10)/24,IF(AND(I2="LONDON",I6="FULL TIME"),(I10*7.2)/24,IF(AND(I2="LONDON",I6="PART TIME"),((S6/S10)*I10)/24)))))
The calc converts DAYS into HH:MM, based on location, and contract type. The user enters their CF balance into cell I10.
=IF(I2="REGION","",IF(AND(I2="NATIONAL",I6="FULL TIME"),(I10*7.4)/24,IF(AND(I2="NATIONAL",I6="PART TIME"),((S6/S10)*I10)/24,IF(AND(I2="LONDON",I6="FULL TIME"),(I10*7.2)/24,IF(AND(I2="LONDON",I6="PART TIME"),((S6/S10)*I10)/24)))))