ExcelBanter

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/310906-how-do-i-show-number-hours-negative-using-formula.html)

No Name

How do I show number of hours as a negative using formula?
 
hi,
what format are you using now?
####### could also mean that the column is not wide enough.

-----Original Message-----
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 12:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com