It would be easier to arrange your time-in and time-out data in
columns going across, and then have a different row for each day, but
assuming you have the date in A1, then try this with your current
layout:

=FLOOR((A3-A2+A5-A4)*24 + A7,0.25)

Will round down to 15 min increments. You should have just the hours
in A7.

Hope this helps.

Pete

On Mar 17, 12:01*pm, HRLegal
wrote:
Good Morning -

What I am looking to do is take the time in/time out and add it to the time
in/time out (lunch in the middle); allow for a rounder of 7 minutes, round
down, 8+ round up. *Then add, PTO, Holiday or Bereavement leave for that day.

Here is an example:

* * * * * * * * *Monday, March 17 * * * * * * * * * * * * * * * * Tuesday,
March 18
* * * * * * * * *7:55am * * * * * * * * * * * * * * * * * * * * * * * * 7:52am
* * * * * * * * *12:02pm * * * * * * * * * * * * * * * * * * * * * * * 12:30pm
* * * * * * * * *12:58pm
* * * * * * * * *5:08pm

2.75 - PTO
Total Hours: 8.25 * * * * * * * * * * * * * * * * * * * * * * * * * *7.50

Total hours worked per day, should equal 7.5 or greater.

THANK YOU!