im trying to create a formula on a timesheet that reads a cell with a start time and a cell with an end time. it then deduces how many hours have been worked. The formula i wish to create will subtract time for breaks.

Basically break time runs from 10:00 until 10:15 and lunch runs from 13:35 until 14:00 (not long enough if you ask me).

The formula then will have these IF's in it:

Note: G=time started, H = time ended

IF G>14:00 then H-G

IF G>10:30 & H<14:00 then H-G

IF G<10:00 & H<10:00 then H-G

IF G<10:30 & H>14:00 then H-G-TIMEVALUE("0:40")

IF G>10:30 & H>14:00 then H-G-TIMEVALUE("0:25")

IF G<10:00 & H>10:00 & H<14:00 then H-G-TIMEVALUE("0:15")

Iv been at this for days now but im not sure if its possible to do this all in one formula.

Any suggestions

Chris