| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to minus the time value | Excel Discussion (Misc queries) | |||
| How do I input a minus time in an excel spreadsheet | Excel Worksheet Functions | |||
| how can i show two layers of plus/minus signs for nested groups | Excel Discussion (Misc queries) | |||
| Show minus figures with brackets | Excel Discussion (Misc queries) | |||
| can I get cells with a minus number to show zero | Excel Discussion (Misc queries) | |||
Linear Mode
