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

Tom Ogilvy

How do I show number of hours as a negative using formula?
 
The default date system for windows, 1900 date system, does not support
negative time. Perhaps you can multiply your result by 24 and show it as an
integer or decimal

--
Regards,
Tom Ogilvy

"GBH99" wrote in 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 09:52 AM.

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