I am trying to find out how many deliveries were late.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Ex:<o></o>
G4:G50 - Lists the scheduled delivery time <o></o>
H4:H50 - Lists delivery arrival time (when the shipment actually arrived)<o></o>
<o></o>
I have calculated the time variance between the scheduled time and actual delivery time in X4:X50<o></o>
<o></o>
Now some of the deliveries arrived later than the scheduled time. For example, a delivery may have been scheduled to arrive and 8:00am but arrived at 9:30am. This appears in excel as:<o></o>
<o></o>
G4: 8:00 AM<o></o>
H4: 9:30 AM<o></o>
<o></o>
My formula in X4:<o></o>
=IF(G4 < H4,TEXT(MAX(G4:H4)-MIN(G4:H4),"-h:mm"),TEXT(MAX(G4:H4)-MIN(G4:H4),"h:mm"))<o></o>
<o></o>
This generates a -1:30. Indicating that the delivery was 1 hour 30 minutes late. <o></o>
<o></o>
<o></o>
Now I'm trying to use a CountIf formula to count the number of deliveries that were an hour or more late. <o></o>
<o></o>
I'm currently using the following formula and it is not generating the right count. <o></o>
<o></o>
=COUNTIFS(X3:X50,"<-01:00")<o></o>
<o></o>
<o></o>
Please advise. Thank you.
<o></o>
Ex:<o></o>
G4:G50 - Lists the scheduled delivery time <o></o>
H4:H50 - Lists delivery arrival time (when the shipment actually arrived)<o></o>
<o></o>
I have calculated the time variance between the scheduled time and actual delivery time in X4:X50<o></o>
<o></o>
Now some of the deliveries arrived later than the scheduled time. For example, a delivery may have been scheduled to arrive and 8:00am but arrived at 9:30am. This appears in excel as:<o></o>
<o></o>
G4: 8:00 AM<o></o>
H4: 9:30 AM<o></o>
<o></o>
My formula in X4:<o></o>
=IF(G4 < H4,TEXT(MAX(G4:H4)-MIN(G4:H4),"-h:mm"),TEXT(MAX(G4:H4)-MIN(G4:H4),"h:mm"))<o></o>
<o></o>
This generates a -1:30. Indicating that the delivery was 1 hour 30 minutes late. <o></o>
<o></o>
<o></o>
Now I'm trying to use a CountIf formula to count the number of deliveries that were an hour or more late. <o></o>
<o></o>
I'm currently using the following formula and it is not generating the right count. <o></o>
<o></o>
=COUNTIFS(X3:X50,"<-01:00")<o></o>
<o></o>
<o></o>
Please advise. Thank you.