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)



"Richard" wrote in message
...
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!!!