Hi All,
I can't seem to figure out how to combine two formulas to first combine a date and time in UTC and then convert to PST. I've been trying different combos and just can't seem to get there. Here is an example of the data:
This is what I have to combine the date and time (D), but now I just need to apply the time offset to the D formula. I used the following formula in the E column to convert to PST from the D column. I'm sure it's something simple. I also need to make sure it corrects the date back if minus goes back before mid-night.
Any help with would be much appreciated.
I can't seem to figure out how to combine two formulas to first combine a date and time in UTC and then convert to PST. I've been trying different combos and just can't seem to get there. Here is an example of the data:
This is what I have to combine the date and time (D), but now I just need to apply the time offset to the D formula. I used the following formula in the E column to convert to PST from the D column. I'm sure it's something simple. I also need to make sure it corrects the date back if minus goes back before mid-night.
Any help with would be much appreciated.
1 | A | B | C | D | E |
2 | 100 | Date UTC | Time UTC | Date and Time combined w/PST | Date and Time PST |
3 | 101 | 2/3/2023 | 15:12:18 | =TEXT(B2, "mm/dd/yyyy ")&TEXT(C2, "hh:mm:ss") | =D3+(-8/24) |
Last edited:
