Hi Guys! I'm having a little difficulty with this problem. I have 3 different lunch times depending upon hours of work. They are: 5 hrs, no lunch; 5.5-6.5 hrs, 30 minute lunch; 7+ hrs, 1 hr lunch. So I'm trying to be able to merely punch in my start:end times and have the formula calculate my actual paid work time without the meal times being factored in. Thanks so much for the help. I had a couple of videos I was watching but couldn't find anything with the 3 scenarios. Thanks again for the help! By the way, I'm trying to work horizontally on my spread sheet
<colgroup><col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> </colgroup><tbody>
</tbody>
12/9/2017 |
3:00 PM |
10:30 PM |
7.5 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> </colgroup><tbody>
</tbody>