Hopefully someone can help me with this.
In the attached spreadsheet there is a VB macro that looks at the info in the spreadsheet, seperates it by date, and then gives a sum of the times on the sheet.
What I would like to do is be able to sum by name instead of by date, but I cant get the whole thing to work right.
(i.e. John Doe Log-out duration 5hrs for 12/27 & 12/28 instead of John Doe log-out duration 2.5hrs 12/27; 2.5hrs 12/28)
Can someone look at the code and help me out.
The name of the macro is called BreakCalculations and is performed by pressing ctrl-x.
In the attached spreadsheet there is a VB macro that looks at the info in the spreadsheet, seperates it by date, and then gives a sum of the times on the sheet.
What I would like to do is be able to sum by name instead of by date, but I cant get the whole thing to work right.
(i.e. John Doe Log-out duration 5hrs for 12/27 & 12/28 instead of John Doe log-out duration 2.5hrs 12/27; 2.5hrs 12/28)
Can someone look at the code and help me out.
The name of the macro is called BreakCalculations and is performed by pressing ctrl-x.