Thread: INT,MOD?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default INT,MOD?

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