I have a cell that contains total number of seconds. This is cell D11 and it's value shows, for example, 328302.
In cell E11, I have the following formula to convert this to Days:Hours:Minutes
=INT(D11/86400) & ":" & TEXT((D11/86400)-INT(D11/86400),"hh:mm")
This formula results in a value of 3:19:11
In field F11, I want to show the text 3 Days; 19 Hours; 11 Minutes
If the total seconds would result in 0 days, I want to only show the hours and minutes like 19 Hours; 11 Minutes
And if the total seconds would result in 0 days and 0 hours, I want to only show the minutes like 11 Minutes
Any help with this would be greatly appreciated!
In cell E11, I have the following formula to convert this to Days:Hours:Minutes
=INT(D11/86400) & ":" & TEXT((D11/86400)-INT(D11/86400),"hh:mm")
This formula results in a value of 3:19:11
In field F11, I want to show the text 3 Days; 19 Hours; 11 Minutes
If the total seconds would result in 0 days, I want to only show the hours and minutes like 19 Hours; 11 Minutes
And if the total seconds would result in 0 days and 0 hours, I want to only show the minutes like 11 Minutes
Any help with this would be greatly appreciated!