software

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)/8 This formula works fine for the
available vacation but still gives .50, .25 results
Thanks in advance!

Hi Richard

Try
=INT(SUM(HList!D)/8)amp;quot;Days quot;amp;MOD(SUM(HList!D),8)amp;quot; hoursquot;

--
Regards

Roger Govierquot;Richardquot; gt; wrote in message
...
gt; If you're working in hours, say 8 hour increments. How would you write
gt; the
gt; formula to reflect every 2 hours instead it's displaying halves and
gt; quarters(.50 and .25) I'd like for it to display (.2 hrs or .4hrs or
gt; .6hrs)
gt; Example: If I've schelduled or taken 42 hours vacation and I have 20
gt; days
gt; available. I'd like the results to display ( 5 days and 2 hrs) used.
gt; (14 days
gt; and 6 hrs available) This formula works fine for the scheduled
gt; vacation but
gt; gives .50, .25 results =SUM(HList!D)/8 This formula works fine for
gt; the
gt; available vacation but still gives .50, .25 results
gt; Thanks in advance!
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!

quot;Roger Govierquot; wrote:

gt; Hi Richard
gt;
gt; Try
gt; =INT(SUM(HList!D)/8)amp;quot;Days quot;amp;MOD(SUM(HList!D),8)amp;quot; hoursquot;
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Richardquot; gt; wrote in message
gt; ...
gt; gt; If you're working in hours, say 8 hour increments. How would you write
gt; gt; the
gt; gt; formula to reflect every 2 hours instead it's displaying halves and
gt; gt; quarters(.50 and .25) I'd like for it to display (.2 hrs or .4hrs or
gt; gt; .6hrs)
gt; gt; Example: If I've schelduled or taken 42 hours vacation and I have 20
gt; gt; days
gt; gt; available. I'd like the results to display ( 5 days and 2 hrs) used.
gt; gt; (14 days
gt; gt; and 6 hrs available) This formula works fine for the scheduled
gt; gt; vacation but
gt; gt; gives .50, .25 results =SUM(HList!D)/8 This formula works fine for
gt; gt; the
gt; gt; available vacation but still gives .50, .25 results
gt; gt; Thanks in advance!
gt;
gt;
gt;

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)/8) 1)amp;quot; Days quot;amp;8-MOD(SUM(HList!D),8)amp;quot; hours
leftquot;

--
Regards

Roger Govierquot;Richardquot; gt; wrote in message
...
gt; Thank you so much! It works perfect for the Scheduled or used vacation
gt; but
gt; the Available vacation is getting a #VALUE! probably due to the text?
gt; Thanks
gt; so much. It's still perfect!
gt;
gt; quot;Roger Govierquot; wrote:
gt;
gt;gt; Hi Richard
gt;gt;
gt;gt; Try
gt;gt; =INT(SUM(HList!D)/8)amp;quot;Days quot;amp;MOD(SUM(HList!D),8)amp;quot; hoursquot;
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;Richardquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; If you're working in hours, say 8 hour increments. How would you
gt;gt; gt; write
gt;gt; gt; the
gt;gt; gt; formula to reflect every 2 hours instead it's displaying halves and
gt;gt; gt; quarters(.50 and .25) I'd like for it to display (.2 hrs or .4hrs
gt;gt; gt; or
gt;gt; gt; .6hrs)
gt;gt; gt; Example: If I've schelduled or taken 42 hours vacation and I have
gt;gt; gt; 20
gt;gt; gt; days
gt;gt; gt; available. I'd like the results to display ( 5 days and 2 hrs)
gt;gt; gt; used.
gt;gt; gt; (14 days
gt;gt; gt; and 6 hrs available) This formula works fine for the scheduled
gt;gt; gt; vacation but
gt;gt; gt; gives .50, .25 results =SUM(HList!D)/8 This formula works fine
gt;gt; gt; for
gt;gt; gt; the
gt;gt; gt; available vacation but still gives .50, .25 results
gt;gt; gt; Thanks in advance!
gt;gt;
gt;gt;
gt;gt;
Once again It's perfect! Thanks so very much!!!

quot;Roger Govierquot; wrote:

gt; Hi Richard
gt;
gt; Didn't notice the second part of your request.
gt; Either use 20 for the number of days total holiday available at the
gt; beginning of the formula, or put 20 in a cell (A1 in this example)
gt;
gt; =A1-(INT(SUM(HList!D)/8) 1)amp;quot; Days quot;amp;8-MOD(SUM(HList!D),8)amp;quot; hours
gt; leftquot;
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Richardquot; gt; wrote in message
gt; ...
gt; gt; Thank you so much! It works perfect for the Scheduled or used vacation
gt; gt; but
gt; gt; the Available vacation is getting a #VALUE! probably due to the text?
gt; gt; Thanks
gt; gt; so much. It's still perfect!
gt; gt;
gt; gt; quot;Roger Govierquot; wrote:
gt; gt;
gt; gt;gt; Hi Richard
gt; gt;gt;
gt; gt;gt; Try
gt; gt;gt; =INT(SUM(HList!D)/8)amp;quot;Days quot;amp;MOD(SUM(HList!D),8)amp;quot; hoursquot;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards
gt; gt;gt;
gt; gt;gt; Roger Govier
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Richardquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; If you're working in hours, say 8 hour increments. How would you
gt; gt;gt; gt; write
gt; gt;gt; gt; the
gt; gt;gt; gt; formula to reflect every 2 hours instead it's displaying halves and
gt; gt;gt; gt; quarters(.50 and .25) I'd like for it to display (.2 hrs or .4hrs
gt; gt;gt; gt; or
gt; gt;gt; gt; .6hrs)
gt; gt;gt; gt; Example: If I've schelduled or taken 42 hours vacation and I have
gt; gt;gt; gt; 20
gt; gt;gt; gt; days
gt; gt;gt; gt; available. I'd like the results to display ( 5 days and 2 hrs)
gt; gt;gt; gt; used.
gt; gt;gt; gt; (14 days
gt; gt;gt; gt; and 6 hrs available) This formula works fine for the scheduled
gt; gt;gt; gt; vacation but
gt; gt;gt; gt; gives .50, .25 results =SUM(HList!D)/8 This formula works fine
gt; gt;gt; gt; for
gt; gt;gt; gt; the
gt; gt;gt; gt; available vacation but still gives .50, .25 results
gt; gt;gt; gt; Thanks in advance!
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

I'm almost embarrased to ask for help again. But... on the last formula the
hours doesn't change to 0. It shows the correct Days but instead of 0 it
shows 8 for the hours. The first formula works perfect.

quot;Roger Govierquot; wrote:

gt; Hi Richard
gt;
gt; Didn't notice the second part of your request.
gt; Either use 20 for the number of days total holiday available at the
gt; beginning of the formula, or put 20 in a cell (A1 in this example)
gt;
gt; =A1-(INT(SUM(HList!D)/8) 1)amp;quot; Days quot;amp;8-MOD(SUM(HList!D),8)amp;quot; hours
gt; leftquot;
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Richardquot; gt; wrote in message
gt; ...
gt; gt; Thank you so much! It works perfect for the Scheduled or used vacation
gt; gt; but
gt; gt; the Available vacation is getting a #VALUE! probably due to the text?
gt; gt; Thanks
gt; gt; so much. It's still perfect!
gt; gt;
gt; gt; quot;Roger Govierquot; wrote:
gt; gt;
gt; gt;gt; Hi Richard
gt; gt;gt;
gt; gt;gt; Try
gt; gt;gt; =INT(SUM(HList!D)/8)amp;quot;Days quot;amp;MOD(SUM(HList!D),8)amp;quot; hoursquot;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards
gt; gt;gt;
gt; gt;gt; Roger Govier
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Richardquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; If you're working in hours, say 8 hour increments. How would you
gt; gt;gt; gt; write
gt; gt;gt; gt; the
gt; gt;gt; gt; formula to reflect every 2 hours instead it's displaying halves and
gt; gt;gt; gt; quarters(.50 and .25) I'd like for it to display (.2 hrs or .4hrs
gt; gt;gt; gt; or
gt; gt;gt; gt; .6hrs)
gt; gt;gt; gt; Example: If I've schelduled or taken 42 hours vacation and I have
gt; gt;gt; gt; 20
gt; gt;gt; gt; days
gt; gt;gt; gt; available. I'd like the results to display ( 5 days and 2 hrs)
gt; gt;gt; gt; used.
gt; gt;gt; gt; (14 days
gt; gt;gt; gt; and 6 hrs available) This formula works fine for the scheduled
gt; gt;gt; gt; vacation but
gt; gt;gt; gt; gives .50, .25 results =SUM(HList!D)/8 This formula works fine
gt; gt;gt; gt; for
gt; gt;gt; gt; the
gt; gt;gt; gt; available vacation but still gives .50, .25 results
gt; gt;gt; gt; Thanks in advance!
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;


Hello Richard,

try this amendment to Roger's formula

=A1-CEILING(SUM(Hlist!D)/8,1)amp;quot; Days quot;amp;MOD(8-SUM(Hlist!D),8)amp;quot;
hours leftquot;--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=513975Yes!!! That did the trick, you guys are amaging! Thank you!

quot;daddylonglegsquot; wrote:

gt;
gt; Hello Richard,
gt;
gt; try this amendment to Roger's formula
gt;
gt; =A1-CEILING(SUM(Hlist!D)/8,1)amp;quot; Days quot;amp;MOD(8-SUM(Hlist!D),8)amp;quot;
gt; hours leftquot;
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=513975
gt;
gt;

Nice correction, Dayylonglegs. Thank you.

--
Regards

Roger Govierquot;daddylonglegsquot;
gt; wrote in
message
news:daddylonglegs.23fmlm_1140278101.1538@excelfor um-nospam.com...
gt;
gt; Hello Richard,
gt;
gt; try this amendment to Roger's formula
gt;
gt; =A1-CEILING(SUM(Hlist!D)/8,1)amp;quot; Days quot;amp;MOD(8-SUM(Hlist!D),8)amp;quot;
gt; hours leftquot;
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=513975
gt;