| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing time value
I have 3 working shifts...7a-3p, 3p-11p, and 11p-7a
4/1/2008 1:06:00PM --- this should yield to "7a-3p" shift 4/1/2008 1:13:00AM --- "11p-7a" 4/1/2008 7:04:00PM --- "3p-11p" 4/1/2008 7:00:00AM --- "11p-7a" I wanted to assign above shift value to the time listed above so that accordingly. The data I received didn't have the time listed as military time. This is what I've written, but it didn't return the right value. Help please!!! =IF(B2=" 3:00:00PM","7a-3p",IF(B2<=" 7:00:00AM","7a-3p",IF(B2="11:00:00PM","3p-11p",IF(B2<=" 3:00:00PM","3p-11p","11p-7a")))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| Comparing time values which have milliseconds in them e.g 10:20:30 | Excel Discussion (Misc queries) | |||
| comparing time intervals | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Threaded Mode
