how to find out hours worked between midnight and 6 am

acorn · #1 10-14-2016, 10:06 PM

hi people im stuck on a formula that only works out hours worked between midnight and 6am minus break times. ive attached a screen shot to make it easyer the blue columb is what columb "e" should return. thanks in advance

xor · #2 10-15-2016, 12:29 AM

In D2:

=IF((A2<C2)*(A2>0.25),0,(0.25-A2*(C2>A2)-B2)*24)

acorn · #3 10-15-2016, 01:45 AM

Thanks XOR works a treat ive been look at it for a few days but got no where.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Complicated calculation of hours worked	APreston	Excel	1	05-09-2016 04:42 AM
Very complicated calculation of total hours worked (PLEASE HELP)	APreston	Excel	1	05-08-2016 02:58 AM
Calculate time from midnight on (Weekend hours, Fri-Sat night shift problem)	stormrider2230	Excel	1	01-20-2016 01:41 PM
Help with 'hours worked' calculation...	Snvlsfoal	Excel	1	08-11-2011 05:54 AM
Finding where I last worked on a document.	Balliol	Word	1	11-24-2010 04:50 AM