Hello helpful folks,
I've got an issue with a time card spreadsheet using tables.
I've got a column for date, start time, end time and the number hours:minutes worked (simple subtract start time from end time). Each row is an individual task so there can be several rows for the same day.
I'm able to create another summary table that sums the hours:minutes worked for each day. This uses a SUMIF formula so no matter how many rows there are for a particular date, the hours:minutes worked for that day get summed and display correctly.
All is fine until I sum the hours:minutes in the summary table to get the weekly total. Seems to work fine if the sum of the hours:minutes in the summary table is <= 24, but the total is wrong if > 24. I've tried various methods to get the sum to be correct including different formulas and time formats to no avail.
See attached file. TimeCard.xlsx Any ideas?
Bookmarks