Thread: convert units
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default convert units

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