![]() |
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