| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert units
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert units should include USFt (39.37/12) | Excel Worksheet Functions | |||
| CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
| How do I convert a time units | Excel Discussion (Misc queries) | |||
| Improve Convert function in Excel | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Hybrid Mode
