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? |
#2
|
|||
|
|||
Hi Jennis,
Try setting Tools-Options-tab Calculation-option 1904 data system to ON. To color negative red: - Format-Cells-tab Number - category Custom with code +hh:mm;[Red]-hh:mm Give it a try, Frans "jenniss" wrote in message ... 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? |
#3
|
|||
|
|||
How is your data presented on the spreadsheet? When I place 7:24 in
cell A1 and 6:00 in cell B1, the result of formula in cell C1, =A1-B1, is 1:24. I'm not sure why you'd get the series of ########. As for different fonts or colors when a number is negative, check out Conditional Formatting. Place the cell pointer cell C1 (in this example); on the menu click Format Conditional Formatting. In the window, select "Cell value is" in the first box, "less than" in the middle box, and enter 0 in the last box. Then press the format button and select the format you prefer. |
#4
|
|||
|
|||
How is your data presented on the spreadsheet? When I place 7:24 in
cell A1 and 6:00 in cell B1, the result of formula in cell C1, =A1-B1, is 1:24. I'm not sure why you'd get the series of ########. As for different fonts or colors when a number is negative, check out Conditional Formatting. Place the cell pointer cell C1 (in this example); on the menu click Format Conditional Formatting. In the window, select "Cell value is" in the first box, "less than" in the middle box, and enter 0 in the last box. Then press the format button and select the format you prefer. |
#5
|
|||
|
|||
thanks your a star you solved my problem, your pure geniuos
"Frans van Zelm" wrote: Hi Jennis, Try setting Tools-Options-tab Calculation-option 1904 data system to ON. To color negative red: - Format-Cells-tab Number - category Custom with code +hh:mm;[Red]-hh:mm Give it a try, Frans "jenniss" wrote in message ... 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? |
#6
|
|||
|
|||
Pff, this makes me blush.
I see that you are 'busy', regarding your other postings. Frans. "jenniss" wrote in message ... thanks your a star you solved my problem, your pure geniuos "Frans van Zelm" wrote: etc. |
Reply |
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) |