software

Roger I have been looking at your reply of January 9th to Dave about his
question about a formula for tool rental. I have been trying to get this
formula to work, but I keep coming up with the answer 7920. In using
military in the time out and time in, do these cells need to be format a
special way? If so how do I do that, I think that may be what my problem is.
Thanks in advance,
Gordon
I bet you are entering time as 1100 and 1430. Roger's formula assumes 11:00
and 14:30. To make yours work, try

=(D1 TIME(INT(C1/100),MOD(C1,100),0))-(B1 TIME(INT(A1/100),MOD(A1,100),0))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;BigBuck98quot; gt; wrote in message
...
gt; Roger I have been looking at your reply of January 9th to Dave about his
gt; question about a formula for tool rental. I have been trying to get this
gt; formula to work, but I keep coming up with the answer 7920. In using
gt; military in the time out and time in, do these cells need to be format a
gt; special way? If so how do I do that, I think that may be what my problem
is.
gt; Thanks in advance,
gt; Gordon
gt;
gt;
Thanks Bob, thats exactl what I was doing.

Gordon

quot;Bob Phillipsquot; gt; wrote in message
...
gt;I bet you are entering time as 1100 and 1430. Roger's formula assumes 11:00
gt; and 14:30. To make yours work, try
gt;
gt; =(D1 TIME(INT(C1/100),MOD(C1,100),0))-(B1 TIME(INT(A1/100),MOD(A1,100),0))
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;BigBuck98quot; gt; wrote in message
gt; ...
gt;gt; Roger I have been looking at your reply of January 9th to Dave about his
gt;gt; question about a formula for tool rental. I have been trying to get this
gt;gt; formula to work, but I keep coming up with the answer 7920. In using
gt;gt; military in the time out and time in, do these cells need to be format a
gt;gt; special way? If so how do I do that, I think that may be what my problem
gt; is.
gt;gt; Thanks in advance,
gt;gt; Gordon
gt;gt;
gt;gt;
gt;
gt;