Formulas, question for Roger Govier

B

BigBuck98

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
 
B

Bob Phillips

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)
 
Top