Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timecard - Calculating Time Error
I have created a time card where employees choose from a drop down box what
time the started, time they left for lunch, returned for lunch, and then left to go home. I have the time in the following columns C D E F G 16 Time In Lunch Out Lunch In Time Out Total Hours Worked I have the following function in G16: =IF(((D16-C16+(C16D16)+F16-E16+(E16F16))*24)8,"ERROR - Please check your hours.",((D16-C16+(C16D16)+F16-E16+(E16F16))*24)). the purpose it to not allow employees to enter more than 8 hours per day and make them enter a time for all four cells. However we are getting errors for such things as: C D E F 16 8:15am 11:30am 12:30am 5:15pm Please advise. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
How do you subtract time as in a timecard to calculate hours work | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
How do I use the timecard template if I am using a time clock and. | New Users to Excel | |||
Calculating effective time from start/end date+time | Excel Worksheet Functions |