What differences are there between "at the end" and "in the end"?

Can we use both expressions "at the end" and "in the end" interchangeably?

For example, are the following sentences equivalent?

1. "I didn't want to take sides, but, in the end, I had to."

2. "I didn't want to take sides, but, at the end, I had to."

Which one is correct and why?

Solution 1:

‘At the end’ can refer to the end of a physical location, like ‘at the end of our hallway’. It can also be used to represent the closing or near completion of something, like ‘at the end of the story’ or ‘at the end of the film’. And, it can also mean the end point of a period in time;  ‘The score was nil nil at the end of the game.’  ‘I am going to go away at the end of the month.’

‘In the end’ means ‘finally’. ‘We all wanted to go to different places, in the end, we agreed to go to the beach.’  ‘We waited for the bus for 2 hours, in the end, we caught a taxi.’

Solution 2:

From : http://www.learnersdictionary.com In the end / at the end Tuesday December 6th 2011 Question In the end / at the end Answer

Isaac, from Israel, asked about the difference between in the end and at the end, and when to use them.

In the end

In the end is used mostly as an idiom that means "finally," "after a long time," or, "when everything is considered." It is often followed by a comma. Here are some sentences with this idiom:

We worked hard, and in the end, we achieved our goal.
In the end, what really matters in a friendship is trust.

At the end

At the end is used in the idiom "at the end of the day." which means something similar to in the end (= when everything is considered). However, at the end is most commonly used more literally, as a prepositional phrase followed by of, to refer to the end of a specific noun. This noun can be a physical object, a period of time, an event, a place, or something more abstract, such as one's patience.

Here are some sentences with "at the end + of":

At the end of his life, he had no regrets.
Put a period at the end of every sentence.
I pay the phone bill at the end of each month.
There is a brick building at the end of the driveway.