Sum up employees working at a given hour

[Lenci10]

Hi Experts!

I am trying to sum up employees working at a given hour based on different shifts. In the first table there is the format which from i'm trying to sum the employees and in the second I did it with sumifs formula but i ran into trouble with overnight shifts. Is there a way to solve this without including the date in the shift's start/end hours?

Thank you four your help in advance.

[AliGW]

Why not this?

=SUMIFS(C:C,B:B,">="&H3,A:A,"<="&H3)

You haven't shown us the values you are expecting!

[samba_ravi]

Change B6 to 25:00:00 OR 01-01-1900 01:00:00
and B7 to 26:00:00 OR 01-01-1900 02:00:00
like H22 and H23

[Lenci10]

Thank you I did not even notice that the after midnight hours have a +1 value to them in the form of 1900-01-01, now it is working fine

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.