Something happened in the posting, what is in your message is not what I
posted. I used

=((J7-G7)-IF(AND(H7<"",I7<""),I7-H7,0))*24

note the < between H7 and "" and I7 and ""

Please re-try with this formula.

--
HTH

Bob Phillips

"ChefBoiRD" wrote in message
...

Bob Phillips Wrote:
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!


--
ChefBoiRD