StJohn Hawkes
New Member
- Joined
- Mar 24, 2018
- Messages
- 2
difficult to explain, but probably simple to do, if only I knew how!
I have rows headed "Name", "Month" and "Time" I need excel to read the name in the "Name" column and sum all the entries in the "time" column where the name in the row has the same number in the "month" column and place the sum of time in the cell next to the last time entry. Time is listed in minutes but I would like the "Total to date" column to read in hours and minutes.
Name month task time total to date
smith J 2 ..... 35 35
jones B 1 ....... 50 50
Adams c 3 ....... 46 35
smith C 1 ....... 10 10
smith j 2 ....... 10 20
Jones B 1 ....... 25 75
Adams C 1 ........ 40 86
I have rows headed "Name", "Month" and "Time" I need excel to read the name in the "Name" column and sum all the entries in the "time" column where the name in the row has the same number in the "month" column and place the sum of time in the cell next to the last time entry. Time is listed in minutes but I would like the "Total to date" column to read in hours and minutes.
Name month task time total to date
smith J 2 ..... 35 35
jones B 1 ....... 50 50
Adams c 3 ....... 46 35
smith C 1 ....... 10 10
smith j 2 ....... 10 20
Jones B 1 ....... 25 75
Adams C 1 ........ 40 86