convert units

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"

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!



"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
>
>

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
> >