Greetings,
Perhaps a similar question has been posted, but I cannot find it...I apologize if I am replicating a question.
I have a spreadsheet that lists incidents by date and time. I need to create a summary table of the data that indicates the number of incidents that occurred between 00:00-02:59, 03:00-05:59, 06:00-0859, etc.
Times are formated to view HH:MM, but are stored as hh:mm:ss AM/PM, so I am not having any luck with typing in simple IF statements. I tried formatting the time to text or numbers, but cannot retain the leading zeros. There must be a way to do this, but I am baffled. Any help would be much appreciated!
Thanks in advance!!
-Jen
Perhaps a similar question has been posted, but I cannot find it...I apologize if I am replicating a question.
I have a spreadsheet that lists incidents by date and time. I need to create a summary table of the data that indicates the number of incidents that occurred between 00:00-02:59, 03:00-05:59, 06:00-0859, etc.
Times are formated to view HH:MM, but are stored as hh:mm:ss AM/PM, so I am not having any luck with typing in simple IF statements. I tried formatting the time to text or numbers, but cannot retain the leading zeros. There must be a way to do this, but I am baffled. Any help would be much appreciated!
Thanks in advance!!
-Jen