Quote:
|
Originally Posted by Bob Phillips
Shorter and simpler at the very least vbg
=((J7-G7)-IF(AND(H7"",I7""),I7-H7,0))*24
--
HTH
Bob Phillips
snip
|
I tried it but excel would only accept it without the quotations after (H7"",I7""). Then, I would get "#NAME?" error...may need the HOUR MINUTE in there somewhere??? Will experiment some more... Thanks!