Hi folks, Basil from Manila here. Been using Excel for more than a decade now but I'm far from being an expert as my knowledge is limited to our applications of spreadsheets in our office.
Very cool forum you got here. I like the fact that you could get credible advice from experts through the internet.
I normally use Google whenever I encounter problems with Excel, or anything else for that matter. But I seem to have encountered a problem that Google doesn't have an answer to, something that's probably elementary for the members of the forum. Hope you guys could help me.
The spreadsheet that I am having a problem with is a time log tracker that basically computes for total minutes spent per work done, and also computes for the accumulated mins doing all the tasks. Users enter the start / end time of their work, the "Minutes Spent" column computes (="end time cell" - "start time cell") correctly but for some reason, the sum of the minutes spent just gets messed up when a certain cell, and all the cells that come after it, is filled in with data. Please see screenshot. The 1st image shows the sum of column G upto cell g53...but normally I use =sum(g:g). Upto this point the sum I'm getting is correct. But once I include cell g54 in the equation, the total gets messed up (bottom image). I tried tweaking the cell format, checking for discrepancies in the formulas, but can't seem to find a problem. The "total unpaid hours" column seems to be computing correctly but It might eventually get the same problem. I created the file using Excel 2010 and tried using Excel 2003 (copy pasted the data and applied the formulas) and still encountered the problem. Thanks in advance.
View attachment Time Log Test.xls
Very cool forum you got here. I like the fact that you could get credible advice from experts through the internet.
I normally use Google whenever I encounter problems with Excel, or anything else for that matter. But I seem to have encountered a problem that Google doesn't have an answer to, something that's probably elementary for the members of the forum. Hope you guys could help me.
The spreadsheet that I am having a problem with is a time log tracker that basically computes for total minutes spent per work done, and also computes for the accumulated mins doing all the tasks. Users enter the start / end time of their work, the "Minutes Spent" column computes (="end time cell" - "start time cell") correctly but for some reason, the sum of the minutes spent just gets messed up when a certain cell, and all the cells that come after it, is filled in with data. Please see screenshot. The 1st image shows the sum of column G upto cell g53...but normally I use =sum(g:g). Upto this point the sum I'm getting is correct. But once I include cell g54 in the equation, the total gets messed up (bottom image). I tried tweaking the cell format, checking for discrepancies in the formulas, but can't seem to find a problem. The "total unpaid hours" column seems to be computing correctly but It might eventually get the same problem. I created the file using Excel 2010 and tried using Excel 2003 (copy pasted the data and applied the formulas) and still encountered the problem. Thanks in advance.
View attachment Time Log Test.xls