W
Willem
Dear readers.
I have a report showing competition entries with dates and times in seperate
fields, dates are in the 12/02/2004 format and the times are in the 13:50:23
format. The reports runs over a period of a few weeks.
I need to extract the following from it:
-Amount of entrants per week. (I made a hap hazard system for this but will
simplify it later, if you have something I can use please)
-Amount of entrants per day per week to make a weekly graph.
-Count the amount of entries per hour per day to make a graph from it so
that we can see what the trends are in entering.
I bought the book Excel formulas and it has helped me a lot but I can not
get this right. Please assist if possible.
Thank you.
I have a report showing competition entries with dates and times in seperate
fields, dates are in the 12/02/2004 format and the times are in the 13:50:23
format. The reports runs over a period of a few weeks.
I need to extract the following from it:
-Amount of entrants per week. (I made a hap hazard system for this but will
simplify it later, if you have something I can use please)
-Amount of entrants per day per week to make a weekly graph.
-Count the amount of entries per hour per day to make a graph from it so
that we can see what the trends are in entering.
I bought the book Excel formulas and it has helped me a lot but I can not
get this right. Please assist if possible.
Thank you.