I am trying to create an excel spreadsheet where I am tracking my time between three different areas for each day of the week. Then add the time for each area and create the percentage of time spent each day and for the week on each of these areas. I am having a problem with the total of all the times.
I have the spreadsheet set up so that I am calculating the difference for each project/area. Then taking a sum of all the time for each area/day and setting that in a table. When I try to add the sums for each day for the total that week, it is not adding properly and I don't know what to do. If you highlight the cells for each day -- together, they add up correctly, but if I just do sum (a2:a5), it does not come out with the same answer. I also tried multipying by 24 but that comes out even weirder. Suggestions?
Copy of file attached. Look at cell H11 and H12 on both tabs.
I have the spreadsheet set up so that I am calculating the difference for each project/area. Then taking a sum of all the time for each area/day and setting that in a table. When I try to add the sums for each day for the total that week, it is not adding properly and I don't know what to do. If you highlight the cells for each day -- together, they add up correctly, but if I just do sum (a2:a5), it does not come out with the same answer. I also tried multipying by 24 but that comes out even weirder. Suggestions?
Copy of file attached. Look at cell H11 and H12 on both tabs.