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?
|