Hello, I looked up this formula on Excel forums, but when I use it, it doesn't give me the right result as you can see in the attached file.
=IF(INT(L17/24)=0,"",INT(L17/24)&" Days ")&IF(HOUR(MOD(L17,24)/24)=0,MINUTE(MOD(L17,24)/24)&" Minutes",HOUR(MOD(L17,24)/24)&" Hours")
Can somebody help me please?
Thank you.
DAL
=IF(INT(L17/24)=0,"",INT(L17/24)&" Days ")&IF(HOUR(MOD(L17,24)/24)=0,MINUTE(MOD(L17,24)/24)&" Minutes",HOUR(MOD(L17,24)/24)&" Hours")
Can somebody help me please?
Thank you.
DAL
Attachments

28.4 KB Views: 5