Dock times

[sannel23]

Hi everyone,

I work on scheduling dock times for Sam's Club, Costco and so on. I'm trying to figure out a formula that will give me the sum of dock times before 8am and after 8am. The one that was originally set up is not working. Any help would be greatly appreciated.

 

[DeficientOptimism]

I would probably convert your times into proper 24 hour format like 20:00 for 8pm.

Are you trying to actually sum the times or count the occasions before and post 8am?

If so - you should use a a version of COUNTIFS.

After you've formatted in 24 hour format

=COUNTIFS(F$6:F$54, "<"&"8:00") Prior to 8am =COUNTIFS(F$6:F$54, ">"&"8:00") Post 8am

 

[sannel23]

Thank you for the response. Sorry to clarify I'm looking to count total before and after 8am. So that way I can balance out our routes with primaries and reloads evenly.

 

[sannel23]

I would probably convert your times into proper 24 hour format like 20:00 for 8pm.

Are you trying to actually sum the times or count the occasions before and post 8am?

If so - you should use a a version of COUNTIFS.

After you've formatted in 24 hour format

=COUNTIFS(F$6:F$54, "<"&"8:00") Prior to 8am =COUNTIFS(F$6:F$54, ">"&"8:00") Post 8am

This worked perfectly. Thank you again.