Forum Discussion
Write negative hours in Excel cell
Has the cell been correctly formatted with user defined formatting ([hh]: mm)?
Also remember that the time must be entered here with a colon
... and (that is actually the whole point) summarize the minus time in quotation marks and closing characters: =-"10:12".
Sometimes it can happen that Excel only displays pound signs «########» in cells that contain minus times.
It will work with the input if you enable the 1904 option in your Excel.
To be able to expect negative times, proceed as follows:
1. Call up the "Options" entry in the "File" tab.
2. Select the "Advanced" entry in the left-hand area.
3 In the right part of the window, scroll all the way down.
4. Select the Use 1904 Date Values check box.
5. Confirm with OK.
* Subjects enabling 1904 dates. However, you should not do this unless you are aware of the possible consequences.
Hope I was able to help you with this info.
NikolinoDE
I know I don't know anything (Socrates)
- Thanks to all
