Is there any easy way to tally up the minutes and seconds?

[Burrgogi]

I've been watching a TV series and recorded the runtime of each episode. In column A, I have something like:

52:32
53:26
52:44
etc.

I'd like to subtract 1 min and 38 sec from each of these numbers and get a grand total at the end.

I could easily calculate it by hand but I have nearly ~70 of these and that would take quite some time. Is there any way to do this using a formula?

 

[Burrgogi]

What exactly is in the cell & is 52:32 meant to be 52 hours 32 mins or 52 mins 32 secs

All the episodes are less than 1 hour so the times I listed in my OP are mm:ss.

All I did was copy & paste your formula in a test worksheet.

 

[Ezguy4u]

Burrgogi I did make a little error on my format of time. Maybe [h]:mm:ss would be a better custom format. The good news is you have some examples to choose from.

20-09-15 time.xlsx
	A	B	C	D	E
1	Time		Subtract from each time
2	0:52:32		0:01:38		0:50:54
3	0:53:26				0:51:48
4	0:52:44				0:51:06
5			Grand Total		2:33:48
Time format

Cell Formulas
Range	Formula
E2:E4	E2	=A2-$C$2
E5	E5	=SUM(E2:E4)