Subtract based on Ending Time
 

Columns:
Late, Sick, Coaching, Meeting, Training

When a person is out for any of these reasons, the time start and end are
entered onto a sheet (time format)

Times range from 7:00 am to 6:45am (every 15 minutes).
At any given time, there are a number of people present, however, if PersonA
is not present from ex: 7:30AM to 8:00AM because of training (could be any
of the reasons), I need to calculate the number of people present. When
8:00AM hits (PersonA comes back), I need the calculation to add him back as
present when that time has arrived.

EX:
PersonA Has a meeting from 7:30Am to 8:00Am.
In my sheet, I enter the Meeting start time and meeting end time.
On another sheet, I am subtracting all persons out at any given time from
the total that should be present. However, When 8:00AM hits, the total
present will be increased by 1, because PersonA has returned (at least thats
what the Meeting End time records).

Any suggestions?

Thank you so much
Terry V

Subtract based on Ending Time
 

Terry

Try

Application.Ontime (time stamp),"subroutine"

"terryv" wrote:

Columns:
Late, Sick, Coaching, Meeting, Training

When a person is out for any of these reasons, the time start and end are
entered onto a sheet (time format)

Times range from 7:00 am to 6:45am (every 15 minutes).
At any given time, there are a number of people present, however, if PersonA
is not present from ex: 7:30AM to 8:00AM because of training (could be any
of the reasons), I need to calculate the number of people present. When
8:00AM hits (PersonA comes back), I need the calculation to add him back as
present when that time has arrived.

EX:
PersonA Has a meeting from 7:30Am to 8:00Am.
In my sheet, I enter the Meeting start time and meeting end time.
On another sheet, I am subtracting all persons out at any given time from
the total that should be present. However, When 8:00AM hits, the total
present will be increased by 1, because PersonA has returned (at least thats
what the Meeting End time records).

Any suggestions?

Thank you so much
Terry V