Hi,
just wanted to ask if there is a way to automatically convert the time/date and add it correspondingly to the correct date?
currently i am using Philippine time and i wanted to convert it to PST.
for example, PH Time/Date is 4/3 2:30 AM, if i convert it to PST, it would be 4/2 11:30 AM.
would just want to automatically generate the Convert to PST Table either using the Normal Time Zone Table or the Convert PH to PST Table.
just wanted to ask if there is a way to automatically convert the time/date and add it correspondingly to the correct date?
currently i am using Philippine time and i wanted to convert it to PST.
for example, PH Time/Date is 4/3 2:30 AM, if i convert it to PST, it would be 4/2 11:30 AM.
would just want to automatically generate the Convert to PST Table either using the Normal Time Zone Table or the Convert PH to PST Table.
Book1.xlsx | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
1 | Normal Time Zone (PH Time) | Converted to PST | ||||||||||||||||
2 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | ||||
3 | 1-Apr | 2-Apr | 3-Apr | 4-Apr | 5-Apr | 6-Apr | 7-Apr | 1-Apr | 2-Apr | 3-Apr | 4-Apr | 5-Apr | 6-Apr | 7-Apr | ||||
4 | Emp 1 | 4/1/2024 20:00 | 4/2/2024 20:00 | 4/3/2024 20:00 | 4/4/2024 20:00 | 4/5/2024 20:00 | OFF | OFF | 4/1/2024 5:00 | 4/2/2024 5:00 | 4/3/2024 5:00 | 4/4/2024 5:00 | 4/5/2024 5:00 | OFF | OFF | |||
5 | Emp 2 | OFF | OFF | 4/3/2024 2:30 | 4/4/2024 2:30 | 4/5/2024 2:30 | 4/6/2024 2:30 | 4/7/2024 1:30 | OFF | 4/2/2024 11:30 | 4/3/2024 11:30 | 4/4/2024 11:30 | 4/5/2024 11:30 | 4/6/2024 10:30 | OFF | |||
6 | Emp 3 | OFF | 4/2/2024 2:30 | 4/3/2024 2:30 | 4/4/2024 2:30 | 4/5/2024 2:30 | 4/6/2024 2:30 | OFF | 4/1/2024 11:30 | 4/2/2024 11:30 | 4/3/2024 11:30 | 4/4/2024 11:30 | 4/5/2024 11:30 | OFF | OFF | |||
7 | ||||||||||||||||||
8 | Convert PH to PST | |||||||||||||||||
9 | Emp 1 | 4/1/2024 5:00 | 4/2/2024 5:00 | 4/3/2024 5:00 | 4/4/2024 5:00 | 4/5/2024 5:00 | OFF | OFF | ||||||||||
10 | Emp 2 | OFF | OFF | 4/2/2024 11:30 | 4/3/2024 11:30 | 4/4/2024 11:30 | 4/5/2024 11:30 | 4/6/2024 10:30 | ||||||||||
11 | Emp 3 | OFF | 4/1/2024 11:30 | 4/2/2024 11:30 | 4/3/2024 11:30 | 4/4/2024 11:30 | 4/5/2024 11:30 | OFF | ||||||||||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B9:H11 | B9 | =IFERROR(B4-"15:00","OFF") |