Best way to format cells for entry...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Not sure if this is the best way, but I would create my template with the 60
rows of tasks and label the worksheet "Minutes" then copy that worksheet to a
new worksheet and label that one "# of Tasks". You could sort each worksheet
to determine the information you are trying to retrieve. You could total
each column (location) and format the answer accordingly.
 
Back
Top