how do i get excel to show time in minus?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 Crawt said:
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?
Click to expand...

The easiest way would be to use the 1904 date system.
 
Thank you for answering my question.
I've been trying for ages to sort this out and now I have, thanks to you.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i calculate negative hours in excel 2
Minus Key Results in EXT Message in Status Bar 8
How to remove a - sign after the number 9
What does "--" (2 minus signs) do in a formula 1
How to handle a minus sign "-" as text not as part of a formula? 2
How can I show negative numbers in brackets in spreadsheet 4
Excel How to calculate percentage for time 1
strip minus signs from right to left 2

Back
Top