Format question

[Richard]

Whenever I use this formula to show days, it returns a string of decimal
places like 3.66666666 days. I would like for it to show something like 3
days 6 hours. Here is the formula I'm using =SUM(G:G)/L1&"Days" Thanks in
advance!!!

 

[Sean Timmons]

You could do =INT(sum(G:G)/L1)&" Days "&(sum(G:G)/L1-INT(sum(G:G)/L1))*24&"
Hours.

..66667 days is more like 16 hours...

 

[Bob Phillips]

=INT(SUM(G:G)/L1)&" Days "&TEXT(MOD(SUM(G:G)/L1,1),"hh") &" hours"

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Bob Phillips]

If it will always be less than 31 days you could also use

=TEXT(SUM(G:G)/L1,"d ""Days ""h ""hours""")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)