ExcelBanter - how to use time format to present negative value? ex. -00:42 min

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to use time format to present negative value? ex. -00:42 min (https://www.excelbanter.com/excel-discussion-misc-queries/22423-how-use-time-format-present-negative-value-ex-00-42-min.html)

hass

how to use time format to present negative value? ex. -00:42 min

Don Guillett

--
Don Guillett
SalesAid Software

"hass" wrote in message
...

JE McGimpsey

Tools/Options/Calculation, check the 1904 Date System checkbox.

Bob Phillips

This isn't even funny anymore, there are so many people not bothering to add
message body. Uurgh!

"Don Guillett" wrote in message
...

--
Don Guillett
SalesAid Software

"hass" wrote in message
...

hass

thanks this solved the problem

"JE McGimpsey" wrote:

Tools/Options/Calculation, check the 1904 Date System checkbox.

All times are GMT +1. The time now is 08:53 PM.