| 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);_(* "-"??_);_(@_) |
| 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 | |||
Threaded Mode
