Figuring total hours in military time going passed midnight.

I need a formula for figuring military time passed midnight.

Our day shift starts at 0500 and ends around 1900. The night shift starts around 1700 and ends around 0700 the next day. All i need is total hours. Right know for the day shift i use the formula

=(text(e3,"00\:00")-text(d3,"00\:00"))*24. Im putting this in column "i". When leaving blank leaves a 0 which is fine. For the days this is ok.

For the nights i just added a +1 which leaves me a 24 in column "i" when e and d are left blank. Need to show 0. Ive tryed several differant formulas havent had any luck.

I need to calculate total ticket times which again my problem is the night shift. What i need is a formula if possible that can be used for tickets that might end before midnight or tickets that may end sometime after midnight or tickets that may start after midnight and ending after.

Dont know if possible for a formula to do all three so can use one across the board. For this reason we have contract workers that may start at any time.

I need one complicated formula to do one simple thing. Just one to be able to calculate totals hours with any military time put in.

If anyone can help me with this it would be very appreciated.

Thanks

Thanks shg this worked what would i need to change to get to show in 1/4 hours.

Well this gave me the same result. We enter time in 1/4 hours need it to add and subtract in 1/4 hours dont want to round up or down.

Yes that is correct. Shg's formula is rounding to the nearest 100 so 2115 to 0330 is showing 6.
2100 to 330 showing 7 needs to be 6.5. 2145 to 330 showing 6 needs 5.75. Im copying and pasting
what i have entered.

=if(count(c7:d7)<2,"",24*mod(text(d7,"00\:00")-text(c7,"00\:00"), 1))

Well that was it i should have known that. Works like was wanting. Thank you guys so much.