Hi I'm a little confused.
I have a sheet that has a lot of times. There is a column that compares the times and advises the number of minutes between anything less than 5 minutes is a clash with different levels with 00:00:00 being a direct clash.
what I'm trying to do is count the number of times different clashes appear and the amount of minutes.
example - direct clash is 00:00:00 then 00:01:00 then 00:02:00 etc. 00:00:00 works correctly but 00:01:00 brings up 0 even though I know there is entries.
the code I'm using is =COUNTIF(E9:E750,"00:00:00") =COUNTIF(E9:E750,"00:01:00") etc
can anyone advise what I'm doing wrong and why excel doesn't determine the difference. I would attach the file but it says I cannot post attachments, can upload it somewhere if anyone wants to see.
Cheers
I have a sheet that has a lot of times. There is a column that compares the times and advises the number of minutes between anything less than 5 minutes is a clash with different levels with 00:00:00 being a direct clash.
what I'm trying to do is count the number of times different clashes appear and the amount of minutes.
example - direct clash is 00:00:00 then 00:01:00 then 00:02:00 etc. 00:00:00 works correctly but 00:01:00 brings up 0 even though I know there is entries.
the code I'm using is =COUNTIF(E9:E750,"00:00:00") =COUNTIF(E9:E750,"00:01:00") etc
can anyone advise what I'm doing wrong and why excel doesn't determine the difference. I would attach the file but it says I cannot post attachments, can upload it somewhere if anyone wants to see.
Cheers