mianmazher
Active Member
- Joined
- Jan 24, 2004
- Messages
- 412
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Time | Consumption | ||||
2 | Start | 10:00 | 45 | |||
3 | 15:25 | 46.2 | ||||
4 | 20:25 | 47 | ||||
5 | 40:00:00 | 48 | ||||
6 | 50:10:00 | 46 | ||||
7 | End | 60:00:00 | 45.25 | |||
8 | ||||||
9 | Average | 46.464525 | ||||
Sheet1 |
In Column B I have the time values in the text format which represent minutes and seconds
in Column A I have to write the start and the Stop as shown
If start and stop are in the position as shown above then the average should be 46.464525
If the start is entered in A3 and End in A7 then the Average should be
46.664525
in the same way if the end is shifted up or down the average changes automatically
Hope that u people understand what I trying to say
Waiting for someone to help
Regards
Mian Mazher