[solved] int,mod?

[Richard]

If A8 has =A4+B3+F4+F5+F6 And it's all numbers. How would you format it to
show Days and hours in cell A8, example 4.5 = 4 days 4 hours

[Gary''s Student]

Use:
=INT(A4+B3+F4+F5+F6) & " days " & MOD(A4+B3+F4+F5+F6,1)*8 & " Hours"

for an eight hour day (like a work day)
--
Gary's Student


"Richard" wrote:

> If A8 has =A4+B3+F4+F5+F6 And it's all numbers. How would you format it to
> show Days and hours in cell A8, example 4.5 = 4 days 4 hours