ExcelBanter - INT,MOD?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - INT,MOD? (https://www.excelbanter.com/excel-discussion-misc-queries/104600-int-mod.html)

Richard

INT,MOD?

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

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

All times are GMT +1. The time now is 08:29 PM.