Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF(ISNUMBER(A1),A1,--LEFT(A1,FIND(" ",A1)-1))
- =IF(ISNUMBER(A1),B1,IF(ISNUMBER(--(RIGHT(A1,1) & TEXT(B1,"H:MM AM/PM"))),--(RIGHT(A1,1) & TEXT(B1,"H:MM AM/PM")),--(RIGHT(A1,1) & B1)))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement