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 in Computers & Internet ➔ Software
It is input as 12 hour time, I guess. I have to manually enter "1:00 pm".
2007-02-28 14:24:48 · update #1
A B C D E
clockin clockout lunchstart lunchstop totalwork
8:00am 6:00pm 1:00pm 2:00pm =(B1-A1)-(D1-C1)
make sure all columns are formated to show time like you want.
2007-02-28 14:22:25 · answer #1 · answered by ecoandy 2 · 1⤊ 0⤋
Hey dont worry its easy. In the cell where you get the total number of hours that you have worked for the day, the formula might have been modified(which is adding the lunch hour also to the actual number of working hours). You need to select the cell wher you get total hours, check the formula. check what is the cell number for the lunch hour (example A6, B12, ... ); now check this cell address in the formula of the total hours worked field & just delete this address only.
This should help you. But sometimes, what heppens is though you will be edit one row(or for one day) in this way; the next day you come maybe you will face the same issue. In that case, the formula has actually been applied to all the cells under the total hours worked column. You just need to check in the main cell and drag it downwards through the entire column for this field.
Hope you understood this. Its easy to do it; hard to explain !
Best of luck!
2007-02-28 22:24:43 · answer #2 · answered by Queenie 2 · 1⤊ 0⤋
question.....When putting in your time, is it put in the cells in 24 hour time? or 12 hour time?
ecoandy has it right. I tried it in excel, like the other answer states, make sure the cells are formatted in the time you want and all the same. Ecoandy's answer is right.
2007-02-28 22:17:29 · answer #3 · answered by rcpton 2 · 0⤊ 0⤋