See if this will do for you (it does not include the terms Hours, Minutes, Seconds in teh answer but does show the hrs, mins and secs...
=INT(A1/60/60/24)&" Days & "&TEXT(MOD(A1/60/60/24,1),"hh:mm:ss")&" Hours"
=1 Days & 01:01:06 Hours
See if this will do for you (it does not include the terms Hours, Minutes, Seconds in teh answer but does show the hrs, mins and secs...
=INT(A1/60/60/24)&" Days & "&TEXT(MOD(A1/60/60/24,1),"hh:mm:ss")&" Hours"
=1 Days & 01:01:06 Hours
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks