A3 | B3 | D3 | E3 | |

Monday | Monday | Tuesday | Tuesday | |

Time In | Time Out | Time In | Time Out | Total Hours |

10:00 | 13:00 | 10:00 | 18:00 | 11.00 |

<tbody>

</tbody>

So, because there is an 8 hour shift, I want the total hours to say 10.30 not 11.00

Here is the data I have for these two days. (I have it filled out for all 7 days in each week, but I cut it down to make it easier) (Data was too long so I had to put image sorry)

<a3),((b3-a3)*24)+24,(b3-a3)*24)),2)+round(if((or(d3="",e3="")),0,if((e3<d3),((e3-d3)*24)+24,(e3-d3)*24)),2)

<a3),((b3-a3)*24)+24,(b3-a3)*24)),2)+round(if((or(d3="",e3="")),0,if((e3<d3),((e3-d3)*24)+24,(e3-d3)*24)),2)

<a3),((b3-a3)*24)+24,(b3-a3)*24)),2)

<a3),((b3-a3)*24)+24,(b3-a3)*24)),2)

<a3),((b3-a3)*24)+24,(b3-a3)*24)),2)

I hope that's not to much to ask for. I've reached a dead end. I've looked at tons of different options but they all want me to include a "Time in, Time out" column. But I really don't want that.</a3),((b3-a3)*24)+24,(b3-a3)*24)),2)></a3),((b3-a3)*24)+24,(b3-a3)*24)),2)

</a3),((b3-a3)*24)+24,(b3-a3)*24)),2)

</a3),((b3-a3)*24)+24,(b3-a3)*24)),2)+round(if((or(d3="",e3="")),0,if((e3<d3),((e3-d3)*24)+24,(e3-d3)*24)),2)

</a3),((b3-a3)*24)+24,(b3-a3)*24)),2)+round(if((or(d3="",e3="")),0,if((e3<d3),((e3-d3)*24)+24,(e3-d3)*24)),2)