Hi
Would be grateful for any help regarding my excel query. I have a spreadsheet with a number of columns relating to parcels delivered. One of the columns (column C) relates to parcels delivered before 09:00, before 10:00 and before 12:00. There is another column (column E) that shows when these parcels were delivered in the format HH:MM:SS.
I need to establish the number of parcels by type in column C i.e. before 09:00, before 10:00 etc that were delivered on time as stated in column E. this will then tell me the number of parcels with a before 09:00 delivery that were delivered before 09:00 and allows me to work out a % delivered before 09:00. I have tried using Countifs but keep getting an error, formula I am using is as below.
=COUNTIFS(C3:C600,"Before 09:00",E3:E603,"<=09:00:00")
Kind regards
Would be grateful for any help regarding my excel query. I have a spreadsheet with a number of columns relating to parcels delivered. One of the columns (column C) relates to parcels delivered before 09:00, before 10:00 and before 12:00. There is another column (column E) that shows when these parcels were delivered in the format HH:MM:SS.
I need to establish the number of parcels by type in column C i.e. before 09:00, before 10:00 etc that were delivered on time as stated in column E. this will then tell me the number of parcels with a before 09:00 delivery that were delivered before 09:00 and allows me to work out a % delivered before 09:00. I have tried using Countifs but keep getting an error, formula I am using is as below.
=COUNTIFS(C3:C600,"Before 09:00",E3:E603,"<=09:00:00")
Kind regards