I have a spreadsheet €“ with 60 rows of Tasks on the left side and 75 columns
of Cities on the top. Each City has two different inputs for each
row/task, i.e., for the task in Row 3 - Baltimore takes 15 minutes to
complete the task and performs the task 4 times.

I want to be able to sort each task showing which City (1) takes the least
amount of mins and performs the task the least amount of times and (takes
the most amount of mins and performs the task the most amount of time; I
will also need to have a total amount of minutes (converted to hours) for
each City (taking into account if task is performed multiple times).

What is the best way to enter the information and format the cell to achieve
this? Thanks