UTC to PST in Excel
Convert UTC to US Pacific Time inside a spreadsheet. Copy the formula below, paste it next to your UTC value, and Excel returns the PST date and time — date rollover included automatically.
Use this live converter to check a result, then use the Excel formula below to convert a whole column.
Excel formula
Pacific Time covers the US West Coast and western Canada. It shifts between PST (UTC−8) and PDT (UTC−7) with daylight saving. Native Excel has no built-in time-zone database, so it cannot automatically tell whether a given UTC date falls in standard or daylight time — you choose the correct formula for the date you're converting.
Standard time PST
=A2-TIME(8,0,0)
Daylight time PDT
=A2-TIME(7,0,0)
2026 transition dates: US clocks move to daylight time on March 8, 2026 and back to standard time on November 1, 2026 (the rule is the second Sunday in March and the first Sunday in November each year). If your UTC date falls between those two dates, use the daylight-time formula; otherwise use the standard-time formula.
Worked example
Put your UTC date and time in one cell, the formula in the next, and read the PST result.
PST, standard time:
| Cell | Contains |
|---|---|
| A2 | 2026-01-15 23:00 |
| B2 | =A2-TIME(8,0,0) |
| C2 | 2026-01-15 15:00 |
PDT, daylight time:
| Cell | Contains |
|---|---|
| A2 | 2026-07-15 23:00 |
| B2 | =A2-TIME(7,0,0) |
| C2 | 2026-07-15 16:00 |
Date rollover example
Because the formula operates on Excel's combined date+time serial number, a result that crosses midnight automatically shows the correct new date — you don't need separate logic for this.
| Cell | Contains |
|---|---|
| A2 | 2026-01-16 03:00 (UTC) |
| B2 | =A2-TIME(8,0,0) |
| C2 | 2026-01-15 19:00 (PST) |
Formatting the cells
Format both the UTC input cell and the result cell as a custom date/time so Excel displays a readable value instead of a raw serial number.
Input format
Select cell A2 → Format Cells → Custom → enter yyyy-mm-dd hh:mm
Output format
Apply the same custom format to the result cell (C2) so the PST value displays the same way, not as a decimal number.
Converting a whole column
Enter the formula once in the result column, then fill it down to apply it to every row.
| Cell | Contains |
|---|---|
| A2:A100 | UTC date/time values |
| B2 | =A2-TIME(8,0,0) |
| B2:B100 | Fill B2 down to match every row in column A |
Related tools
Frequently asked questions
Put your UTC date and time in one cell, then in another cell use =A2-TIME(8,0,0) for standard time or =A2-TIME(7,0,0) for daylight time.
For standard time: =A2-TIME(8,0,0). For daylight time: =A2-TIME(7,0,0). Use whichever matches the date you're converting.
No. Standard Excel formulas have no built-in time-zone database, so they can't tell which offset applies to a given date on their own. You need to pick the standard-time or daylight-time formula based on the date, using the transition dates above.