I need help with creating a custom time format

[smllchng5]

So I am trying to create a custom cell format to show the Turn around time for a task. For example, someone spend 11 hours and 30 minutes on a task. I have the formula written to calculate the TAT, but it shows as 11:30 as the time it took, but I want that to show as 1.44 (or in in other words....11 hours spent in an 8 hours a day = 1 day and 3.5 hours ~ divded by 8 hours in a day is .4375...so final should be something like 1.44 (rounded up) I know it all has to do with the way the cell is formatted, but I am unclear what the proper format should be. Can you help me write the custom cell format please? Thanks in advance for your help.

 

[Asbestos_Jen]

To add to the above, you could add the formula from either M or N to the end of the formula in P to eliminate all the extra cells, and then format whichever way you want.

 

[smllchng5]

Thank you so much. That worked. I so appreciate your help. I know it took some time, but so grateful I have what I need.

 

[Asbestos_Jen]

Glad to have helped!