I have trying to do a rota time sheet in Excel. At the bottom of the sheet it
totals up the number of hours for each person, but when I calculate this
against a budget hours figure it won't give me a negative for short hours.
Can anyone help.