| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format for negative time
I'm attempting to format cells to recognize cells that are greater than minus
19 minutes (-0:19). So far, it won't work. I've tried using a ' before and after the time but to no avail. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format for negative time
Use a formula of
=C1-TIME(0,19,0) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "mailrail" wrote in message ... I'm attempting to format cells to recognize cells that are greater than minus 19 minutes (-0:19). So far, it won't work. I've tried using a ' before and after the time but to no avail. Any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format for negative time
Thanks Bob but when I use that, it (like when I tried it one my own) formats
every single cell (whether less than the negative 19 minutes or not) with the condition that I have used. I have to use the 1904 date system to get Excel to recognize the negative time in the calculation. Is this causing a problem? "Bob Phillips" wrote: Use a formula of =C1-TIME(0,19,0) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "mailrail" wrote in message ... I'm attempting to format cells to recognize cells that are greater than minus 19 minutes (-0:19). So far, it won't work. I've tried using a ' before and after the time but to no avail. Any suggestions? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format for negative time
No, it works fine for me with 1904 date system as well.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "mailrail" wrote in message ... Thanks Bob but when I use that, it (like when I tried it one my own) formats every single cell (whether less than the negative 19 minutes or not) with the condition that I have used. I have to use the 1904 date system to get Excel to recognize the negative time in the calculation. Is this causing a problem? "Bob Phillips" wrote: Use a formula of =C1-TIME(0,19,0) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "mailrail" wrote in message ... I'm attempting to format cells to recognize cells that are greater than minus 19 minutes (-0:19). So far, it won't work. I've tried using a ' before and after the time but to no avail. Any suggestions? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format for negative time
Sorry to be so dense, but do I type in your formula exactly as you've written
after I change the drop-down to "formula is" in the CF area? Remember...in my cell, the value that I'm trying to format actually shows up (for instance) as -0:23. Could that be causing a problem? "Bob Phillips" wrote: No, it works fine for me with 1904 date system as well. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "mailrail" wrote in message ... Thanks Bob but when I use that, it (like when I tried it one my own) formats every single cell (whether less than the negative 19 minutes or not) with the condition that I have used. I have to use the 1904 date system to get Excel to recognize the negative time in the calculation. Is this causing a problem? "Bob Phillips" wrote: Use a formula of =C1-TIME(0,19,0) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "mailrail" wrote in message ... I'm attempting to format cells to recognize cells that are greater than minus 19 minutes (-0:19). So far, it won't work. I've tried using a ' before and after the time but to no avail. Any suggestions? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format for negative time
Yes you do, but the way I have written it assumes that the selected cell, or
the first of the selected cells, is C1. If not change the formula accordingly. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "mailrail" wrote in message ... Sorry to be so dense, but do I type in your formula exactly as you've written after I change the drop-down to "formula is" in the CF area? Remember...in my cell, the value that I'm trying to format actually shows up (for instance) as -0:23. Could that be causing a problem? "Bob Phillips" wrote: No, it works fine for me with 1904 date system as well. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "mailrail" wrote in message ... Thanks Bob but when I use that, it (like when I tried it one my own) formats every single cell (whether less than the negative 19 minutes or not) with the condition that I have used. I have to use the 1904 date system to get Excel to recognize the negative time in the calculation. Is this causing a problem? "Bob Phillips" wrote: Use a formula of =C1-TIME(0,19,0) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "mailrail" wrote in message ... I'm attempting to format cells to recognize cells that are greater than minus 19 minutes (-0:19). So far, it won't work. I've tried using a ' before and after the time but to no avail. Any suggestions? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format for negative time
That did it. Thanks for putting up with me today Bob.
"Bob Phillips" wrote: Yes you do, but the way I have written it assumes that the selected cell, or the first of the selected cells, is C1. If not change the formula accordingly. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "mailrail" wrote in message ... Sorry to be so dense, but do I type in your formula exactly as you've written after I change the drop-down to "formula is" in the CF area? Remember...in my cell, the value that I'm trying to format actually shows up (for instance) as -0:23. Could that be causing a problem? "Bob Phillips" wrote: No, it works fine for me with 1904 date system as well. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "mailrail" wrote in message ... Thanks Bob but when I use that, it (like when I tried it one my own) formats every single cell (whether less than the negative 19 minutes or not) with the condition that I have used. I have to use the 1904 date system to get Excel to recognize the negative time in the calculation. Is this causing a problem? "Bob Phillips" wrote: Use a formula of =C1-TIME(0,19,0) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "mailrail" wrote in message ... I'm attempting to format cells to recognize cells that are greater than minus 19 minutes (-0:19). So far, it won't work. I've tried using a ' before and after the time but to no avail. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Negative Time Format | Excel Discussion (Misc queries) | |||
| Time in a negative format? | Excel Discussion (Misc queries) | |||
| How do I display time in a negative format? | Excel Worksheet Functions | |||
| Get Excel to accept negative values using time-format | Excel Discussion (Misc queries) | |||
| how to use time format to present negative value? ex. -00:42 min | Excel Discussion (Misc queries) | |||
Linear Mode
