Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating am or pm shift
Ive been asked to create a formula to tell whether a single cells time is either AM or PM shift. Our AM shift is 05:45 to 15:45 while our PM shift is 15:46 to 01:15 the next day.
B3 is formatted to: m/d/yyyy h:mm and contains 1/2/2019 3:50:19 PM Ive tried =IF(AND(B3=TIMEVALUE("05:45:00"),B3<=TIMEVALUE("1 5:45:00")),"AM","PM") While the results show PM and this is correct, the cell above it contains 1/02/2019 3:13:24 and should result in AM €¦ but it results in PM as well. What am I doing wrong? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating am or pm shift
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating time for 3rd shift | Excel Worksheet Functions | |||
Formula for shift schedule & calculating future dates - 2003 | Excel Discussion (Misc queries) | |||
How 2 use right shift "<<" and left shift "" operator in excel? | Excel Programming | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
CALCULATING WORKSHEETS (INCLUDING AGE CALCULATING SHEETS) FOR DOWNLOADING, GREAT FOR PENSIONS/LIFE INSURANCE CALCULATIONS! | Excel Programming |