how do i get excel to show time in minus?
 

I have a spreadsheet which works out my working hours. Sometimes, the answer
is a minus but excel just shows a lot of hash signs.
It won't show the time as minus.

How can I fix this?

how do i get excel to show time in minus?
 

Either:
1 Multiply by 24 to convert to hours and change format to general or
number to display in decimal hours, or
2 Tools/ Options/ Calculation: select 1904 date system, but be careful
in that case if you are transferring date data to & fro between 1900 and
1904 systems.
--
David Biddulph

"David Crawt" <David wrote in message
...
I have a spreadsheet which works out my working hours. Sometimes, the
answer
is a minus but excel just shows a lot of hash signs.
It won't show the time as minus.

How can I fix this?

how do i get excel to show time in minus?
 

David Crawt <David wrote...
I have a spreadsheet which works out my working hours. Sometimes, the answer
is a minus but excel just shows a lot of hash signs.
It won't show the time as minus.

How can I fix this?

The easiest way would be to use the 1904 date system.

how do i get excel to show time in minus?
 

Thank you for answering my question.
I've been trying for ages to sort this out and now I have, thanks to you.

"David Biddulph" wrote:

Either:
1 Multiply by 24 to convert to hours and change format to general or
number to display in decimal hours, or
2 Tools/ Options/ Calculation: select 1904 date system, but be careful
in that case if you are transferring date data to & fro between 1900 and
1904 systems.
--
David Biddulph

"David Crawt" <David wrote in message
...
I have a spreadsheet which works out my working hours. Sometimes, the
answer
is a minus but excel just shows a lot of hash signs.
It won't show the time as minus.

How can I fix this?