# Time formula help

~Jeff~
Guest
Posts: n/a

 13th May 2004
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

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

Bob Phillips
Guest
Posts: n/a

 13th May 2004
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
>
>
> --
> ~Jeff~
> [Microsoft Windows XP Pro,Office 2000]
>
>

Ron Rosenfeld
Guest
Posts: n/a

 13th May 2004
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
>

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

--ron

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?Um9ieQ==?= Microsoft Access Forms 5 21st Oct 2006 06:06 PM Jonathan Windows XP General 10 13th Jan 2005 03:22 AM Janet Microsoft Excel Misc 5 14th Jul 2004 08:30 PM Healingbear Microsoft Excel Misc 1 28th Jan 2004 11:30 PM -\$- Windows XP Internet Explorer 2 21st Dec 2003 11:45 PM

Features