convert units

[Guest]

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

 

[Guest]

try:
=INT(A1/24) & " days " & A1-INT(A1/24)*24 & " hr"

 

[daddylonglegs]

Try this formula

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

 

[Guest]

Many thanks!

 

[Guest]

many Thanks!

try:
=INT(A1/24) & " days " & A1-INT(A1/24)*24 & " hr"