View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lelynx lelynx is offline
external usenet poster
 
Posts: 1
Default Group a set of 'time'

Hi,

I have a set of data in time format as such...

0:10:38
0:10:36
0:08:57
0:31:44
0:30:39
0:29:19
0:28:23
0:28:15
0:25:09

What i want to do is to do a count to get something like this...
range count
0 - 5 min 0
6 - 10 min 10
11 min 15


How can i do this in Excel?