Hi
Column F contains the total of hours for each day. Column G contains the hours multiplied by the hourly rate of pay. Column H contains the week number. Column I contains the Weekday number.
At the end of each day "Bob" inputs his start and end times into the first available row of this time sheet and the formulae mentioned above spring into action
I want to display the Grand total of hours and money earned for a given week in two separate columns, but I only want those figures to show on the last day of the week worked by that employee.
For example, Bob worked on Monday, Thursday and Friday last week. So i need the total of his hours and money earned only to appear next to his Friday row. If next week he only works on a Monday, then that's where the totals will appear. (In columns J and K respectively)
So this is where I'm stuck - I know how to do a SUMIF() and return the total worked/earned for a given working week next to EVERY cell, but i don't know how to return an empty string in the other cells so that there is only one figure showing per week.
To put a spanner in the works, i'm using Excel 2003, so some array formulas that worked at home in Excel 2010 don't work here.
Thanks for any help
Column F contains the total of hours for each day. Column G contains the hours multiplied by the hourly rate of pay. Column H contains the week number. Column I contains the Weekday number.
At the end of each day "Bob" inputs his start and end times into the first available row of this time sheet and the formulae mentioned above spring into action
I want to display the Grand total of hours and money earned for a given week in two separate columns, but I only want those figures to show on the last day of the week worked by that employee.
For example, Bob worked on Monday, Thursday and Friday last week. So i need the total of his hours and money earned only to appear next to his Friday row. If next week he only works on a Monday, then that's where the totals will appear. (In columns J and K respectively)
So this is where I'm stuck - I know how to do a SUMIF() and return the total worked/earned for a given working week next to EVERY cell, but i don't know how to return an empty string in the other cells so that there is only one figure showing per week.
To put a spanner in the works, i'm using Excel 2003, so some array formulas that worked at home in Excel 2010 don't work here.
Thanks for any help
Last edited:
