Time Formula

Quick question...

I have 2 columns. Column A has "My Possession Time", column B has "Opponent Possession Time." There is a max time of 20:00 (20 minutes). In cell E4 I have put 20:00. I am using: =(e4-a1) to auto-generate my opponents possession time given that his time of poss will be the difference between my time subtracted from 20 minutes. I want to be able to just drag this formula down so I can apply it to my other rows... I have over 140 rows.

Any help would be greatly appreciated?

Originally Posted by LieDetector

Quick question...

I have 2 columns. Column A has "My Possession Time", column B has "Opponent Possession Time." There is a max time of 20:00 (20 minutes). In cell E4 I have put 20:00. I am using: =(e4-a1) to auto-generate my opponents possession time given that his time of poss will be the difference between my time subtracted from 20 minutes. I want to be able to just drag this formula down so I can apply it to my other rows... I have over 140 rows.

Any help would be greatly appreciated?

Please Login or Register  to view this content.

Rgds