|
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);_(* "-"??_);_(@_) |
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);_(* "-"??_);_(@_) |
| All times are GMT +1. The time now is 02:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com