I have a cell that equals the remaining number of hours of vacation pay. I
would like to have a cell next to that that would indicate how many work
days are left figuring the work day is 8 hours.

Example:
Cell A1:
59

Cell B1:
7 days and 3 hours

Example 2:
Cell A1:
148.5

Cell B1:
18 days and 4.5 hours

Thanks in advance,

--
~Jeff~
[Microsoft Windows XP Pro,Office 2000]

Hi Jeff,.

=INT(A1/8) & " days and " & A1-INT(A1/8)*8 & " hours"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"~Jeff~" <~Jeff~@~nomail~.com> wrote in message
news:(E-Mail Removed)...
> I have a cell that equals the remaining number of hours of vacation pay. I
> would like to have a cell next to that that would indicate how many work
> days are left figuring the work day is 8 hours.
>
> Example:
> Cell A1:
> 59
>
> Cell B1:
> 7 days and 3 hours
>
> Example 2:
> Cell A1:
> 148.5
>
> Cell B1:
> 18 days and 4.5 hours
>
> Thanks in advance,
>
> --
> ~Jeff~
> [Microsoft Windows XP Pro,Office 2000]
>
>

On Thu, 13 May 2004 09:38:42 -0400, "~Jeff~" <~Jeff~@~nomail~.com> wrote:

>I have a cell that equals the remaining number of hours of vacation pay. I
>would like to have a cell next to that that would indicate how many work
>days are left figuring the work day is 8 hours.
>
>Example:
>Cell A1:
>59
>
>Cell B1:
>7 days and 3 hours
>
>Example 2:
>Cell A1:
>148.5
>
>Cell B1:
>18 days and 4.5 hours
>
>Thanks in advance,


=INT(A1/8)& " days and " & MOD(A1,8) & " hours"


--ron