Also, the date is written in the format YYYYMMDD, just to make things more confusing.
The column that shows times (clocked in, clocked out, etc.) is right next to a column that shows the date (which is entered as a number rather than a date). To make matters worse, the column that shows times does not only show time clocked in and time clocked out it also shows the times at which various work tasks were performed throughout the day (between the clock-in and clock-out times).Īnyway, my boss wants me to figure out the total number of work hours recorded on the spreadsheet, and I have no idea how to proceed. Instead there is one column for both times. Unfortunately, as I said, there are not separate columns for the clock-in and clock-out times. If there were separate columns for those values, I could calculate the total hours worked on the first day/row, and then I could drag the formula down the entire spreadsheet. I need to calculate the hours worked by this individual each day over the course of all the years shown on the spreadsheet, but there are NOT separate columns for time clocked in and time clocked out. The spreadsheet is about 30,000 rows long and very poorly organized (more on this below). I have a spreadsheet that shows the amount of time that somebody worked over the course of several years. Here are links to the other places that I've posted it: First of all, I have cross-posted the question below because it pertains to my job.
0 kommentar(er)
