Spreadsheet: 854093d1704073305-how-do-i-add-a-time-to-a-cell-based-on-a-value-in-another-column-idata-export
Sheet: IDATA

DATE | DAY | TIME | DAY AND TIME | PRICE | POINTS | TREND | TIME NOTE
2024-01-01 00:00:00 |  | 18:00:00 |  |  | 0 |  | GLOBEX OPEN
 |  |  |  |  |  |  | HOD
 |  |  |  |  |  |  | ASIAN KILL ZONE OPEN
 |  |  |  |  |  |  | LOD
 |  |  |  |  |  |  | ASIAN KILL ZONE CLOSE
 |  | 1 day, 0:00:00 |  |  |  |  | MIDNIGHT CLOSE
 |  | 00:00:00 |  |  |  |  | MIDNIGHT OPEN
 |  |  |  |  |  |  | DAILY HIGH
 |  |  |  |  |  |  | DAILY LOW
 |  | 02:00:00 |  |  |  |  | LONDON KILL ZONE OPEN
 |  | 05:00:00 |  |  |  |  | LONDON KILL ZONE CLOSE
 |  | 08:30:00 |  |  |  |  | NEW YORK AM KILL ZONE OPEN
 |  | 08:30:01 |  |  |  |  | 8:31:00 OPEN
 |  | 09:30:00 |  |  |  |  | EQUITIES OPEN
 |  |  |  |  |  |  | HIGH
 |  | 10:00:00 |  |  |  |  | NEWS EVENT
 |  | 10:00:01 |  |  |  |  | NEWS EVENT
 |  |  |  |  |  |  | NEW YORK AM KILL ZONE CLOSE
 |  |  |  |  |  |  | LOW
 |  | 01:30:00 |  |  |  |  | NEW YORK PM KILL ZONE OPEN
 |  |  |  |  |  |  | NEW YORK PM KILL ZONE CLOSE
 |  | 17:00:00 |  |  |  |  | GLOBEX CLOSE
 |  | 18:00:00
 |  |  |  |  |  |  | GLOBEX OPEN
 |  | 19:00:00 |  |  |  |  | ASIAN KILL ZONE OPEN
 |  | 21:00:00 |  |  |  |  | ASIAN KILL ZONE CLOSE
 |  | 1 day, 0:00:00 |  |  |  |  | MIDNIGHT CLOSE
 |  | 00:00:00 |  |  |  |  | MIDNIGHT OPEN
 |  |  |  |  |  |  | LONDON KILL ZONE OPEN
 |  |  |  |  |  |  | LONDON KILL ZONE CLOSE
 |  |  |  |  |  |  | NEW YORK AM KILL ZONE OPEN
 |  |  |  |  |  |  | 8:31:00 OPEN
 |  |  |  |  |  |  | EQUITIES OPEN
 |  |  |  |  |  |  | NEWS EVENT
 |  |  |  |  |  |  | DAILY LOW
 |  |  |  |  |  |  | NEW YORK AM KILL ZONE CLOSE
 |  |  |  |  |  |  | DAILY HIGH
 |  |  |  |  |  |  | NEW YORK PM KILL ZONE OPEN
 |  |  |  |  |  |  | NEWS EVENT
 |  |  |  |  |  |  | NEW YORK PM KILL ZONE CLOSE
 |  |  |  |  |  |  | GLOBEX CLOSE
 |  |  |  |  |  |  | GLOBEX OPEN
 |  |  |  |  |  |  | GAP
 |  |  |  |  |  |  | ASIAN KILL ZONE OPEN
 |  |  |  |  |  |  | ASIAN KILL ZONE CLOSE
 |  |  |  |  |  |  | MIDNIGHT CLOSE
 |  |  |  |  |  |  | MIDNIGHT OPEN
 |  |  |  |  |  |  | LONDON KILL ZONE OPEN
 |  |  |  |  |  |  | LONDON KILL ZONE CLOSE
 |  |  |  |  |  |  | DAILY HIGH
 |  |  |  |  |  |  | NEWS EVENT
 |  |  |  |  |  |  | NEW YORK AM KILL ZONE OPEN
 |  |  |  |  |  |  | EQUITIES OPEN
 |  |  |  |  |  |  | NEW YORK AM KILL ZONE CLOSE
 |  |  |  |  |  |  | NEW YORK PM KILL ZONE OPEN
 |  |  |  |  |  |  | DAILY LOW
 |  |  |  |  |  |  | NEW YORK PM KILL ZONE CLOSE
 |  |  |  |  |  |  | GLOBEX CLOSE
 |  |  |  |  |  |  | GAP
 |  |  |  |  |  |  | GLOBEX OPEN
 |  |  |  |  |  |  | ASIAN KILL ZONE OPEN
 |  |  |  |  |  |  | ASIAN KILL ZONE CLOSE
 |  |  |  |  |  |  | MIDNIGHT CLOSE
 |  |  |  |  |  |  | MIDNIGHT OPEN
 |  |  |  |  |  |  | LONDON KILL ZONE OPEN
 |  |  |  |  |  |  | LONDON KILL ZONE CLOSE
 |  |  |  |  |  |  | 5:31:00 OPEN
 |  |  |  |  |  |  | DAILY LOW
 |  |  |  |  |  |  | NEWS EVENT
 |  |  |  |  |  |  | 8:31:00 OPEN
 |  |  |  |  |  |  | EQUITIES OPEN
 |  |  |  |  |  |  | NEW YORK AM KILL ZONE CLOSE
 |  |  |  |  |  |  | NEW YORK PM KILL ZONE OPEN
 |  |  |  |  |  |  | DAILY HIGH
 |  |  |  |  |  |  | NEW YORK PM KILL ZONE CLOSE
 |  |  |  |  |  |  | GLOBEX CLOSE