D
drum118
Having a problem using time in my calulation.
Trying to find out the number of people that past a point for
1,2,3,4,5,6,7,8,9,10,15,20,30 minutes in columns head while I have 55,
100, 160 and 200 in rows. I have sum=(55*(60/col))
Col 1 2 3 4 5 6 7 8 9 10 15 20 30 minutes
55 3300
102
155
300
Then I want to use 5,000 divided by the rows/cols further down the
sheet using the same time figures. I try doing sum=(5000/row/(60/col))
where the results should climb as the time gets higher, but results is
off/
Col 1 2 3 4 5 6 7 8 9 10 15 20 30 minutes
55 97
102 49
155 32
300 17
Any help is welcome
Thanks
Trying to find out the number of people that past a point for
1,2,3,4,5,6,7,8,9,10,15,20,30 minutes in columns head while I have 55,
100, 160 and 200 in rows. I have sum=(55*(60/col))
Col 1 2 3 4 5 6 7 8 9 10 15 20 30 minutes
55 3300
102
155
300
Then I want to use 5,000 divided by the rows/cols further down the
sheet using the same time figures. I try doing sum=(5000/row/(60/col))
where the results should climb as the time gets higher, but results is
off/
Col 1 2 3 4 5 6 7 8 9 10 15 20 30 minutes
55 97
102 49
155 32
300 17
Any help is welcome
Thanks