| 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 |
| 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 | |||
Threaded Mode
