Hello,

I would really appreciate any help with this. I'm trying to create an excel formula to keep track of Overtime based on date/time range. The Overtime must be counted per 30 mins intervals and 2 separate worksheets. On the first worksheet (Named OT Tracker) the columns ID, Name, Supervisor, Day, Date, OT Starts, OT Ends and Total Hours must be filled depending on the dates of the Overtime per Employee. On the second workseet (named "Coverage by Intervals") we have a table with the dates the Overtime is required as columns and the raws are the hours per 30 minutes intervals on which the OT is required (Example: 15:30 - 16:00, 16:00 - 16:30). What I'm looking for is the following: let's say employee 1 signs up for Overtime on 11/23/2012 from 16:00 to 17:30, once the information is added on the OT Tracker worksheet is added the table on "Coverage by Intervals" should count 1 on the cells for 11/23/2012 for the intervals 16:00 - 16:30, 16:30 - 17:00 and 17:00 - 17:30. If a second employee is added and he wants OT for a number of hours within that range the formula should count 2 on the specified cells.

I already tried with the "countifs" but I keep getting an error. I would really appreciate at least help with how the formula for 1 cell should go so I can keep on working with the others.

Any help is really appreciated

(sorry for my english, not my native)