Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to type a minues figure
i am trying to type a minus figure in excel and it comes up with an error:
the formula you typed contains an error i confirm in the cell i am typing -1:02 and the cell format is +[hh]:mm;[red]-[hh]:mm (i want the hours to exceed 24 hour and i want a minus figure in red) can anyone help me to type a minus figure? |
#2
|
|||
|
|||
jenniss,
In Excel, you cannot directly enter a negative time. You can have a negative time as a result of a formula if you set the date system to the 1904 system - Tools | Options.... Calculation tab, check "1904 date system" Note that using this setting will affect all the time/date calculations in the workbook - for good or for bad. HTH, Bernie MS Excel MVP "jenniss" wrote in message ... i am trying to type a minus figure in excel and it comes up with an error: the formula you typed contains an error i confirm in the cell i am typing -1:02 and the cell format is +[hh]:mm;[red]-[hh]:mm (i want the hours to exceed 24 hour and i want a minus figure in red) can anyone help me to type a minus figure? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Chart: cannot apply the default chart type... | Charts and Charting in Excel | |||
Can I set the numerical type of Cell to Hex format | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Custom Type Charts Problem | Excel Worksheet Functions |