Result required at a particular time interval

mady94

New member
Joined
Apr 14, 2015
Messages
1
Reaction score
0
Points
0
Please help me solve this problem.I hv a excel file in which there are 4 columns namely Vehicle,Start time,End Time,Speed.I want result to come in a way like.
No. of vehicles types crossed along with their average speed at a 5 minute interval.like


Start Time End Time LCV Two wheeler Car small buses car big mini bus 3 auto
vol||Avg Speed vol||Avg Speed


57319.42 62319.42 3 speed/no of entries n so on...


Please check the attached file.
 

Attachments

  • b67.xlsx
    116.8 KB · Views: 17
Back
Top