I am trying to put a formula together that will add hours & subtract out lunch hours on a daily basis. The formula for weeks end is easy, it is the daily one that is hard. The employees would put a time in at 8:30, lunch out at 1:30, lunch in at 2:30, & then out for the day at 5:45. Since the lunch is past 12, the only way I could get this to work was by adding am's & pm's. Can anyone show me a way to do this without having to type am & pm. The reason being is because I have to submit this paper to my finance department & the paper is maxed out at 8.5 x 14 landscape format. If I put the am & pm's in, it pushes it way over the print line on the right. Please help. Thanks in advance.
Edit: I don't want to put in Military time either
Video Tutorials / Excel Dashboards Reports