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

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