ExcelBanter - How do I show number of hours as a negative using formula?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do I show number of hours as a negative using formula? (https://www.excelbanter.com/excel-programming/311125-how-do-i-show-number-hours-negative-using-formula.html)

GBH99

How do I show number of hours as a negative using formula?

I am having trouble formatting a cell so that when the number of hours
someone has completed for work against what they should have worked can show
as a negative value instead of #############################.

All times are GMT +1. The time now is 09:52 AM.