View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken G. Ken G. is offline
external usenet poster
 
Posts: 37
Default Counting time-frames

Not sure about the subject - best description I could come up with.
I have a column which shows elapsed times in hours and minutes for various
jobs. What I want to do is count how many of these fall into various time
frames e.g 1 hour to 1 hour and 30 minutes, 1hour and 31 minutes to 2 hours
etc. All I need is a count. I don't want to have to the sort the sheet to do
this as it needs to be part of the overall sheet, and if possible I'd like to
avoid vba although if that is the only way around it - so be it.