Hello,

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

Thanks and regards,

Luis Serpa

try:
=INT(A1/24) & " days " & A1-INT(A1/24)*24 & " hr"
--
Gary''s Student


"luiss" wrote:

Hello,

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

Thanks and regards,

Luis Serpa

many Thanks!

"Gary''s Student" wrote:

try:
=INT(A1/24) & " days " & A1-INT(A1/24)*24 & " hr"
--
Gary''s Student


"luiss" wrote:

Hello,

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

Thanks and regards,

Luis Serpa

Try this formula

=INT(ROUND(A8,0)/24)&" days, "&MOD(ROUND(A8,0),24)&" hours"


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=514541

Many thanks!



"daddylonglegs" wrote:


Try this formula

=INT(ROUND(A8,0)/24)&" days, "&MOD(ROUND(A8,0),24)&" hours"


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=514541