I have a timecard that I have to submit for work. It is pre-formatted, but it is messed up, to say the least. Let's say that I work a 9 hour day and take a one hour lunch. I enter in the cells start time 8 a.m., end time 6 p.m. That is 10 hours. Then in the lunch column, I enter 1 p.m. to 2 p.m. That is a one hour lunch, total of 9 hours worked. The problem is, the Excel spreadsheet ADDS my lunch to my time, making my payable hours add up to 11. Please help me reformat the cells/columns/whatever! (The person who made the sheet, btw, is even dumber at Excel than I am, apparently.)
2007-02-28
14:08:16
·
3 answers
·
asked by
123
2