Convert to minutes

[DarrenF]

I'm using the below formula and would like to convert it minutes. How would I go about doing that?

=(NETWORKDAYS(C6,D6)-1)*("17:00"-"8:00")+IF(NETWORKDAYS(D6,D6),MEDIAN(MOD(D6,1),"17:00","8:00"),"17:00")-MEDIAN(NETWORKDAYS(C6,C6)*MOD(C6,1),"17:00","8:00")

 

[MARK858]

To convert days to minutes you multiply it by 1440.

 

[DarrenF]

Perfect, thank you. I figured out I needed to add another set of brackets. I was multiplying 1440 on just the last part of the formula which was giving me a negative number. Thanks for your help.