I have been trying to convert the subtracted time to days, hours and minutes but my formula is missing with some functionality which i am unable to track.
I would appreciate your help.
=INT(I4)&" days "&TEXT(I4,"h"" hrs ""m"" mins """)
I have attached a Sheet where i have made all these calculation.
PS: You can change the 9 to a cell that actually contains the value of the shift, in case it can change