Newbie Time Question

  • Thread starter Thread starter ACangemi
  • Start date Start date
A

ACangemi

I have a group of employees that work in shifts (24 Hours). Over th
course of four days we had a "special event" occur. How can I create
formula that spans a four day period & any employee that worked hour
during that four day period would be totaled separately?

Example: Special Event was Thursday Sept 2nd 11:00am through Monda
Sept 6th 10:00pm.

One employee worked 7:30am Thursday Sept 2nd through 4:00pm Thursda
Sept 2... Equals 5hours worked during "special event”. I am only usin
time in & time out for the data.

I understand formulas somewhat, but not time & dates over a four-da
period.


Any suggestions
 
ACangemi,

With the employees names in Column A, Employee Start Time, Employee Stop
Time, Special Event Start Time, Special Even End Time in Columns B, C, E & F
respectively all columns Custom Formatted as "d-mmm-yy * h:mm" (without the
quotes), (or if you prefer "d-mmm-yy * h:mm AM/PM"), enter the formula:

=IF(AND(B2<>"",C2<>""),MIN(C2,$F$2)-MAX(B2,$E$2),"")

in D2 and copy down as far as required. The * in the custom format will
right-align the date and left-align the time to make it look neater.

HTH

Sandy
 
Back
Top