| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TIME SHEET FORMULA CONDITIONS
If possible can a formula used to calculate employee payroll time in and out
be directed to follow certain conditions. Ex: Employee (work schedule 9am-5pm) TIME IN: 9:03 AM TIME OUT: 4:49 PM EXCEL FORMULA WILL CALCULATE THIS TIME IN HOURS ?- EMPLOYEE IS LATE CAN EXCEL BE CONDITIONED INPUT TIME IN TO THE FOLLOWING QUARTER 9:15 AM ?- EMPLOYEE PUNCHED OUT EARLY THIS TIME CAN EXCEL GO BACK TO THE PREVIOUS QUARTER IN OTHER WORDS CAN THE FORMULA BEING TOLD TO CALCULATE FOR A 24 HOUR DAY BUT CALCULATE TO AND BACK TO THE QUARTERS (15, 30, 75 AND ON THE HOUR) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TIME SHEET FORMULA CONDITIONS" ARE THEY POSSIBLE" | Excel Worksheet Functions | |||
| Time sheet Formula | Excel Worksheet Functions | |||
| Time sheet formula? | Excel Discussion (Misc queries) | |||
| Help With Time Sheet Formula | Excel Discussion (Misc queries) | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Threaded Mode
