Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
OK, I am thouroughly confused and need some help. I am trying to compute the
difference in working hours between when an object starts on the line to when it leaves the line, accounting for an 8 hour workday and excluding holidays and weekends, although some saturdays are spent working. Example: Start: 8/10/06 7:00 AM Leave: 8/15/06 10:00 AM Exclude weekend (Sat/Sun) and assume a 8 hour workday. How many total work hours were expended? Is there a simple way to subtract the date/time periods and then convert the days and hours to account for the 8 hour workday. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
amount of working days per month | Excel Discussion (Misc queries) | |||
Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
Working time and days | Excel Worksheet Functions | |||
Working time and days | Excel Discussion (Misc queries) | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |