Once again It's perfect! Thanks so very much!!!

"Roger Govier" wrote:

> Hi Richard
>
> Didn't notice the second part of your request.
> Either use 20 for the number of days total holiday available at the
> beginning of the formula, or put 20 in a cell (A1 in this example)
>
> =A1-(INT(SUM(HList!D:D)/8)+1)&" Days "&8-MOD(SUM(HList!D:D),8)&" hours
> left"
>
> --
> Regards
>
> Roger Govier
>
>
> "Richard" <Richard@discussions.microsoft.com> wrote in message
> news:928E6842-67FB-4666-87CC-F6C2B8DBB832@microsoft.com...
> > Thank you so much! It works perfect for the Scheduled or used vacation
> > but
> > the Available vacation is getting a #VALUE! probably due to the text?
> > Thanks
> > so much. It's still perfect!
> >
> > "Roger Govier" wrote:
> >
> >> Hi Richard
> >>
> >> Try
> >> =INT(SUM(HList!D:D)/8)&"Days "&MOD(SUM(HList!D:D),8)&" hours"
> >>
> >> --
> >> Regards
> >>
> >> Roger Govier
> >>
> >>
> >> "Richard" <Richard@discussions.microsoft.com> wrote in message
> >> news:679C5DC1-A186-4BEC-82E3-67404D67086F@microsoft.com...
> >> > If you're working in hours, say 8 hour increments. How would you
> >> > write
> >> > the
> >> > formula to reflect every 2 hours instead it's displaying halves and
> >> > quarters(.50 and .25) I'd like for it to display (.2 hrs or .4hrs
> >> > or
> >> > .6hrs)
> >> > Example: If I've schelduled or taken 42 hours vacation and I have
> >> > 20
> >> > days
> >> > available. I'd like the results to display ( 5 days and 2 hrs)
> >> > used.
> >> > (14 days
> >> > and 6 hrs available) This formula works fine for the scheduled
> >> > vacation but
> >> > gives .50, .25 results =SUM(HList!D:D)/8 This formula works fine
> >> > for
> >> > the
> >> > available vacation but still gives .50, .25 results
> >> > Thanks in advance!
> >>
> >>
> >>
>
>
>