| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total time vs hours per shift
CAN ANYONE HELP ME WITH THE FORMULAS I NEED BELOW FOR C31, C32 AND C33?
Cell B9 = START TIME AND DATE (EXAMPLE-USER ENTERS DATA) "10/15/07 08:00" B10 = STOP TIME AND DATE (EXAMPLE-USER ENTERS DATA) "10/16/07 16:00" C31 = FIRST SHIFT (BETWEEN 06:00-14:00) HOURS -NEED FORMULA TO GET "14" C32 = SECOND SHIFT(BETWEEN 14:00-22:00) HOURS -NEED FORMULA TO GET "10" C33= THIRD SHIFT(BETWEEN 22:00-06:00) HOURS - NEED FORMULA TO GET "8" C34 = TOTAL RUN TIME -GOT THIS ONE AS =(B10-B9+(B9B10))*24 "32.00" FORMATTED _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total time vs hours per shift
Do a Google search for the thread "Dividing a time span into shifts -
overlapping days" from Feb 2006 in this group. Very similar problem to yours, so the solutions should be applicable. By the way, please don't SHOUT. Hope this helps. Pete On Oct 19, 8:41 pm, "WILSONLA001" <u38391@uwe wrote: CAN ANYONE HELP ME WITH THE FORMULAS I NEED BELOW FOR C31, C32 AND C33? Cell B9 = START TIME AND DATE (EXAMPLE-USER ENTERS DATA) "10/15/07 08:00" B10 = STOP TIME AND DATE (EXAMPLE-USER ENTERS DATA) "10/16/07 16:00" C31 = FIRST SHIFT (BETWEEN 06:00-14:00) HOURS -NEED FORMULA TO GET "14" C32 = SECOND SHIFT(BETWEEN 14:00-22:00) HOURS -NEED FORMULA TO GET "10" C33= THIRD SHIFT(BETWEEN 22:00-06:00) HOURS - NEED FORMULA TO GET "8" C34 = TOTAL RUN TIME -GOT THIS ONE AS =(B10-B9+(B9B10))*24 "32.00" FORMATTED _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Total hours worked during workdays within given shift time. | Excel Discussion (Misc queries) | |||
| calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
| How do I get total hours from 2 date/time cells? | Excel Discussion (Misc queries) | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| Figuring military time for total hours | Excel Worksheet Functions | |||
Hybrid Mode
