Negative times are displayed a ###########
You can overcome that by using the 1904 date/time system, but at a price.
ToolsOptionsCalculation tab, check 1904 date system
Note that all dates in your workbook will change.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Omar" wrote in message ups.com...
| Dear Experts,
| How can I get the real figure if I have the following message?
| Negative times are displayed a ###########.
| Actually I got the above massage from the below formula.
| =2:49 - 3:17, (hh:mm format)
| Thanks.
|
|