I am struggling with calculating time for our truck drivers. I need a formula that will let me get their total hours and then cut ½ hours for lunch. Try as I might I can’t get anywhere with this. My biggest problem is the small pieces of time they work. They start at 9:45 and finish at 3:15...I’m lost can you help!

Rebecca