try this TimeStamp in [Column A] Time from TimeStamp [Column B]: =TIME(HOUR(A2),MINUTE(A2),SECOND(A2)) Shift [Column C]: =IF(AND(B2>=TIME(6,0,0),B2<TIME(13,30,0)),"Shift1",IF(AND(B2>=TIME(0,30,0),B2<TIME(6,0,0)),"Shift3","Shift2"))

Try conditional formatting using formula =A1=MIN(UNIQUE($A$1:$A$23,0,1))

How to VLOOKUP to get Cell Color and Font Color along with Lookup Value quadexcel.com/vlookup-get-ce…

How to Calculate Estimated Travel Time in Excel? quadexcel.com/calculate-esti…

How To Find Merged Cells In Excel quadexcel.com/find-merged-ce…