| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time seperation
Hi Im getting knocked about with this one and sure could use assistance from
someone in the know I am applying the following formula =IF(C12$W$5,(C12-$W$5)*24,IF(C12<$Y$5,($Y$5-C12)*24,"0")) to work shifts i.e.(time format) 4:00 pm to 10:00 pm when increased rate is between 5pm and 6.30 am and normal rate is 6.30am to 5pm. I need the formula to be able to handle all posabilities i.e. 1am to 9am so calculates hrs 1am to 6.30am and next adjacent cell has remaining hrs can you assist |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| Text String Seperation. | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| Seperation of prime and sub inventory units | Excel Worksheet Functions | |||
Threaded Mode
