I need a code to calculate the elapsed time between each "Yes" from the first date in the column 4.
The time is Military hours.
2-Jan-11 No 2400
3-Jan-11 Yes 0950 3350
3-Jan-11 No 1248
3-Jan-11 Yes 1723 0773
4-Jan-11 No 1430
5-Jan-11 No 0050
5-Jan-11 Yes 1230 2200
6-Jan-11 No 2400
7-Jan-11 2400
Bookmarks