software

Hello,

I am trying to convert a number of hours to the format quot;days;hoursquot;. I do
not a precision higher then hour - i.e., do not need fractions of hour. E.g.
50 would appear as quot;2days;02hoursquot;, quot;50,6quot; as quot;2days, 3hoursquot;. What should I
do? I tried the quot;Convertquot; function, but did not manage to find the solution.

Thanks and regards,

Luis Serpatry:
=INT(A1/24) amp; quot; days quot; amp; A1-INT(A1/24)*24 amp; quot; hrquot;
--
Gary''s Studentquot;luissquot; wrote:

gt; Hello,
gt;
gt; I am trying to convert a number of hours to the format quot;days;hoursquot;. I do
gt; not a precision higher then hour - i.e., do not need fractions of hour. E.g.
gt; 50 would appear as quot;2days;02hoursquot;, quot;50,6quot; as quot;2days, 3hoursquot;. What should I
gt; do? I tried the quot;Convertquot; function, but did not manage to find the solution.
gt;
gt; Thanks and regards,
gt;
gt; Luis Serpa
gt;


Try this formula

=INT(ROUND(A8,0)/24)amp;quot; days, quot;amp;MOD(ROUND(A8,0),24)amp;quot; hoursquot;--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=514541Many thanks!
quot;daddylonglegsquot; wrote:

gt;
gt; Try this formula
gt;
gt; =INT(ROUND(A8,0)/24)amp;quot; days, quot;amp;MOD(ROUND(A8,0),24)amp;quot; hoursquot;
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=514541
gt;
gt;

many Thanks!

quot;Gary''s Studentquot; wrote:

gt; try:
gt; =INT(A1/24) amp; quot; days quot; amp; A1-INT(A1/24)*24 amp; quot; hrquot;
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;luissquot; wrote:
gt;
gt; gt; Hello,
gt; gt;
gt; gt; I am trying to convert a number of hours to the format quot;days;hoursquot;. I do
gt; gt; not a precision higher then hour - i.e., do not need fractions of hour. E.g.
gt; gt; 50 would appear as quot;2days;02hoursquot;, quot;50,6quot; as quot;2days, 3hoursquot;. What should I
gt; gt; do? I tried the quot;Convertquot; function, but did not manage to find the solution.
gt; gt;
gt; gt; Thanks and regards,
gt; gt;
gt; gt; Luis Serpa
gt; gt;