Formulas, question for Roger Govier
 

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

Formulas, question for Roger Govier
 

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)

"BigBuck98" wrote in message
...
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

Formulas, question for Roger Govier
 

Thanks Bob, thats exactl what I was doing.

Gordon

"Bob Phillips" wrote in message
...
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)

"BigBuck98" wrote in message
...
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