Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HOW DO I CALCULATE TIME IN A TIME SHEET FOR EXCEL
I AM TRYING TO CALCULATE THE NUMBER OF HOURS WORKED AND THEN SUBTRACTING THE
HOURS TAKEN FOR LUNCH FOR 1 WEEK. FOR EX CELL 1 MOND. TUE WED THUR FRIDA HR IN 10 HR LUN 1 HR BACK 2 HR OUT 6 WHEN I TRY TO CALCULATE THESE HOURS I GET A WRONG ANSWER. I MIGHT HAVE A PROBLEM WITH THE FORMULA. I TRIED SWITCHING THE HOURS TO MILITARY TIME AND STILL DID NOT GET THE ANSWER I WANTED |
#2
|
|||
|
|||
For each day, use
=(B3-B2)+(B5-B4) This will return a time amount, so you would need to format the cell, say B6, as time. If you want decimal hours, multiply by 24. -- HTH RP (remove nothere from the email address if mailing direct) "RAFAEL" wrote in message ... I AM TRYING TO CALCULATE THE NUMBER OF HOURS WORKED AND THEN SUBTRACTING THE HOURS TAKEN FOR LUNCH FOR 1 WEEK. FOR EX CELL 1 MOND. TUE WED THUR FRIDA HR IN 10 HR LUN 1 HR BACK 2 HR OUT 6 WHEN I TRY TO CALCULATE THESE HOURS I GET A WRONG ANSWER. I MIGHT HAVE A PROBLEM WITH THE FORMULA. I TRIED SWITCHING THE HOURS TO MILITARY TIME AND STILL DID NOT GET THE ANSWER I WANTED |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set up weekly time sheet with flexi time. | Excel Worksheet Functions | |||
time sheet calc by time in and out | Excel Worksheet Functions | |||
How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
Calculate time | Excel Worksheet Functions | |||
Multiple worksheet queries | Excel Worksheet Functions |