Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TIME SHEET FORMULA CONDITIONS" ARE THEY POSSIBLE"
I created a time sheet. The time card information is inputted into the time
sheet to calculated with hours worked and rate. This is great until an employee is late or leaves early. Excel will calculate the late time and end time whether employee punched out on time or earlier than the hour. My question is this. Ex: Employees hours 9 am - 5 pm without lunch worked in. Employee punched in late 9:02 (start time should be 9:15 am) Employee punched out earlier than 5 pm punched out at 4:49 pm, (end time should show 4:45 pm). This is the actual time in hours worked. Excel will calculate from 9:02 unitl 4:45 pm. This is actually wrong because employee should be docked a total of an 1/2 hour. Can this formula be created to calculate from quarter to quarter no in between. If punched earlier can it also be created to go back to the quarter previous if punched after the quarter when puching out. please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
Syntax to "OR" 3 "ISERROR" conditions | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |