TImeIn-TimeOut-TimeIn-TimeOut-HoursWorked

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

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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