| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how can i create a formula or format the cells so the answer is a.
I am creating a timetable in excel!
i wish to create a formula that shows a negative result so 7:24 - 06:00 would be - 1:24 not ########## also if this is possible to do can the figure be in the format showing - figure in red when negative and inshowing + figure in black to show positive? does anyone know the answer? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Excel 2003 - cells in formula? | Excel Discussion (Misc queries) | |||
| how do you format a row of cells based upon a value in another ce. | Excel Discussion (Misc queries) | |||
| Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
Threaded Mode
