I am maintaining a time log of time worked using a time-in entry, a time-out
entry and a calculation that subtracts the time-in from the time-out to give
me the hours:minutes worked for each of several officers for each day of the
month. What formula do I use to add the total hours worked for the group at
the end of the month?
Also, I keep a separate duty log of the activities of each officer during
each work day, so there may be as many as 15 or 20 log entries for each
officer for each day of the month. Same question: what formula do I use to
add the total hours:minutes used cumulatively for the whole group for a set
period of time, whether it be for a week, a month, or a quarter?