Wade Smart wrote:
20090409 2038 GMT-6
You got it. That is what I was trying to do.
But I was concentrating on the function and not the numbers, and had to
turn it around, starting at M755. But, it doesnt work either way.
I simplified it down but as soon as you put a IF function inside a IF
function, it stops working. I have found posts that say it can and does
work but Im just missing something :D
wade
20090409 2059 GMT-6
Alright - it just took some working but I finally got it:
=IF(M755=0;IF(K755=0;IF(I755=0;IF(G755=0;E755;G755)))-E754)
E755 = 10:35
G755 = 16:22
I755 = 0
K755 = 0
M755 = 0
This successfully produced 06:02.
:D
Wade
--
Registered Linux User: #480675
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]