Time.

I can`t seem to find a formula.... I want excel to add my work hours up, at the moment I can only get it to add hours up till midnight. I need something that will add my hours if I start at 22:00 Friday and finish at 06:00 Saturday. Showing 2 hours in the Friday
colume and 6 hours in Saturday.At the moment I use
=IF(B3=""," ",(C3-B3+(C3<B3))) this is only good if the whole shift is on the same day. Thanks.