Time formula help

  • Thread starter Thread starter ~Jeff~
  • Start date Start date
J

~Jeff~

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,
 
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)
 
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,
Click to expand...


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


--ron
 
Back
Top