use excel solver to solve this problem

1. You have a band that has recorded 2 albums. Because of Covid, you havent performed an album release concert, so with Covid winding down, you are planning a double-album concert. The concert will be performed in two halves, with an intermission between them. Each album has 9 original songs, and you would like to perform all 18 songs at the concert.

Your albums, with their song lengths (in minutes and seconds), are as follows:

CosmosSing the Blues

Bring on the Sun 3:29Blue Aint So Bad 4:12

Comet 3:34Loose Ends 3:32

Dancin Cross the Universe 4:18Love Me Blue 4:19

Down the Milky Way 6:31My Blue Love 7:27

Heaven 5:33Outta Here 6:07

My Superstar 3:11Precious 3:19

No Country for Spacemen 5:53Suck It Up 5:24

The Space Between Us 4:26Thats How Ya Sing the Blues 4:49

Walkin On The Moon 7:29The Lady Has the Blues 4:12

You would like to determine the optimal set list by assigning these songs to either the first half or the second half of the concert. You would like to meet the following criteria:

a. You would like the two halves to be as close in time as possible.

b. You do not want to perform more than 5 songs from either album before or after intermission. (In other words, you must have at least 4 songs from each album in each half of the concert.)

How should you split your 2 albums up (by assigning songs to either the first half or the second half) in order to meet these criteria? What is the time difference between the two halves?