Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Subtracting Time
I need to subtract one Minute from the value of another cell, sometime the
value will be greater than one minute sometimes less. What I would like it that if value of the cell is greater than one minute I would like the result to appear as a red negitive number, i.e. (0:00:19) Any sugestion on how I can do this. All I get now is a error. Thanks in advance |
#2
|
|||
|
|||
One way:
Tools/Options/Calculation, check the 1904 Date system checkbox. (the 1900 date system can't show negative times without using additional functions). Format time as desired. In article , "Jason" wrote: I need to subtract one Minute from the value of another cell, sometime the value will be greater than one minute sometimes less. What I would like it that if value of the cell is greater than one minute I would like the result to appear as a red negitive number, i.e. (0:00:19) Any sugestion on how I can do this. All I get now is a error. |
#3
|
|||
|
|||
I'll have to remember that in case I ever need it. Could come in handy
sometime. Think I could use negative time when they want it yesterday??? :) -- Carlos "JE McGimpsey" wrote in message ... One way: Tools/Options/Calculation, check the 1904 Date system checkbox. (the 1900 date system can't show negative times without using additional functions). Format time as desired. In article , "Jason" wrote: I need to subtract one Minute from the value of another cell, sometime the value will be greater than one minute sometimes less. What I would like it that if value of the cell is greater than one minute I would like the result to appear as a red negitive number, i.e. (0:00:19) Any sugestion on how I can do this. All I get now is a error. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting Time from NOW() Value | Excel Worksheet Functions | |||
Adding Subtracting Time Formula-Horse Racing | Excel Discussion (Misc queries) | |||
Subtracting time | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions |