Thank you for the quick reply.

This however isn't exactly what I'm looking for. In A1, I need to input not just HKT but also GMT, EDT, etc... I need a formula that will convert the time back to my local time no matter what I put into that cell. I was thinking of using nested IF functions and just subtracting the time based on A1 = the date, A2 = the time and A3 = the time zone.

Maybe there's a way to do it with combining date and time in the same cell. I will continue to explore but let me know if there's another way using this parameters.

Thanks