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?
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?