Bookmarks    
nPr and nCr    
Random Number    
SD Calculator    
Sample Size    
Percent Error    
Density    
Molarity    
Molar Mass    
Ohm's Law    
Watts to Amps    
Voltage Drop    
Long Division    
Mixed Numbers    
Rounding    
Nth Root    
Exponents    
Half-Life    
Polar Form    
De Moivre    
3D Distance    
Point to Line    
Cross Product    
Determinant    
Sin Cos Tan    
Triangle Area    
Scale Factor    
Sector Area    
Ellipse Area    
Cube Volume    
Box Volume    
Sphere Volume    
Cone Volume    
Pipe Volume    
Time Duration    
Time Card    
Present Value    
Future Value    
Churn Rate    
A/B Test Calc    
SEO Traffic    
Ideal Weight    
Fat Intake    
Child Height    
Golf Handicap    
Heat Index    
Wind Chill    
Dew Point    
Download Time    
kWh to Cost    
AC Size (BTU)    
Heating Costs    
LED Savings    
Trip Gas Cost    
Tire Size    
Solar Output    
Solar Payback    
Battery Size    
Wall Area    
Gravel Needed    
Mortar Mix    
Slope Grade    
Curtain Size    
Soil Needed    
Sod Needed    
Ramp Length    
Blind Size    
Drain Slope    
Board Feet    
Heat Loss    
Furniture Fit    
Moving Boxes    
Plywood Cuts    
Shelf Sag    
   Add
Probability and random number calculators
Independent Events
Independent Events
Two Events Solver
Two Events Solver
Repeated Trials
Repeated Trials
Bayes' Theorem
Bayes' Theorem
Expected Value
Expected Value
Binomial Distribution
Binomial Distribution
nPr and nCr
nPr and nCr
Circular Permutation
Circular Permutation
With Repetition
With Repetition
Random Number
Random Number
Averages and statistics calculators
Average Calculator
Average Calculator
Mean Median Mode
Mean Median Mode
SD Calculator
SD Calculator
Quartiles & IQR
Quartiles & IQR
Frequency Table
Frequency Table
Correlation (r)
Correlation (r)
Normal Probability
Normal Probability
Z-Score Calculator
Z-Score Calculator
Confidence Interval
Confidence Interval
Sample Size
Sample Size
Mark & Recapture
Mark & Recapture
P-Value Calculator
P-Value Calculator
Percentage and ratio calculators
Percentage Calc
Percentage Calc
Percent Change
Percent Change
Percent Difference
Percent Difference
Percent Error
Percent Error
Ratio Calculator
Ratio Calculator
Discount Calculator
Discount Calculator
Sales Tax Calculator
Sales Tax Calculator
Margin Calculator
Margin Calculator
Speed calculators
Speed Calculator
Speed Calculator
Density and concentration calculators
Density
Density
Molarity
Molarity
Molar Mass
Molar Mass
Physics and electricity calculators
Ohm's Law
Ohm's Law
Watts to Amps
Watts to Amps
Resistor Colors
Resistor Colors
Voltage Drop
Voltage Drop
Unit conversion calculators
Weight Converter
Weight Converter
Shoe Size Converter
Shoe Size Converter
Integer and signed number calculators
Long Division
Long Division
LCM Calculator
LCM Calculator
GCF Calculator
GCF Calculator
Integer Calculator
Integer Calculator
Prime Factorization
Prime Factorization
Diophantine Solver
Diophantine Solver
Modulo Calculator
Modulo Calculator
Factor Calculator
Factor Calculator
Roman Numerals
Roman Numerals
Fraction, decimal and rounding calculators
Fraction Calculator
Fraction Calculator
Mixed Numbers
Mixed Numbers
Simplify Fractions
Simplify Fractions
Fraction to Decimal
Fraction to Decimal
Decimal to Fraction
Decimal to Fraction
Rounding
Rounding
Equation and inequality calculators
Linear Equation
Linear Equation
Linear Systems
Linear Systems
Quadratic Formula
Quadratic Formula
Absolute Value
Absolute Value
Quadratic Inequality
Quadratic Inequality
Polynomial calculators
Binomial Theorem
Binomial Theorem
Square root and nth root calculators
Simplify Radicals
Simplify Radicals
Nth Root
Nth Root
Exponent and logarithm calculators
Exponents
Exponents
Log Calculator
Log Calculator
Number of Digits
Number of Digits
Scientific Notation
Scientific Notation
Sci. Notation Math
Sci. Notation Math
Half-Life
Half-Life
Complex number calculators
Complex Numbers
Complex Numbers
Polar Form
Polar Form
De Moivre
De Moivre
Function and graph calculators
Slope Calculator
Slope Calculator
Linear Function
Linear Function
Direct & Inverse Variation
Direct & Inverse Variation
y = ax² Calculator
y = ax² Calculator
Distance Formula
Distance Formula
3D Distance
3D Distance
Section Formula
Section Formula
Point to Line
Point to Line
Lat/Long Distance
Lat/Long Distance
Complete the Square
Complete the Square
Circle Equation
Circle Equation
Conic Sections
Conic Sections
Polar Coordinates
Polar Coordinates
Sequence calculators
Arithmetic Sequence
Arithmetic Sequence
Geometric Sequence
Geometric Sequence
Fibonacci Sequence
Fibonacci Sequence
Recurrence Relation
Recurrence Relation
Vector calculators
Vector Calculator
Vector Calculator
Cross Product
Cross Product
Matrix calculators
Matrix Calculator
Matrix Calculator
Determinant
Determinant
Inverse Matrix
Inverse Matrix
Plane geometry calculators
Sin Cos Tan
Sin Cos Tan
Degrees ⇔ Radians
Degrees ⇔ Radians
a sin θ + b cos θ
a sin θ + b cos θ
Triangle Solver
Triangle Solver
Triangle Area
Triangle Area
Right Triangle
Right Triangle
Pythagorean Theorem
Pythagorean Theorem
Polygon Angles
Polygon Angles
Scale Factor
Scale Factor
Parallel Lines
Parallel Lines
Rectangle Area
Rectangle Area
Parallelogram Area
Parallelogram Area
Trapezoid Area
Trapezoid Area
Circle Calculator
Circle Calculator
Sector Area
Sector Area
Inscribed Angle
Inscribed Angle
Ellipse Area
Ellipse Area
Solid geometry calculators
Cube Volume
Cube Volume
Cube Surface Area
Cube Surface Area
Box Volume
Box Volume
Box Surface Area
Box Surface Area
Cylinder Volume
Cylinder Volume
Cylinder Surface
Cylinder Surface
Sphere Volume
Sphere Volume
Sphere Surface
Sphere Surface
Spherical Cap Volume
Spherical Cap Volume
Cap Surface Area
Cap Surface Area
Ellipsoid Volume
Ellipsoid Volume
Ellipsoid Surface
Ellipsoid Surface
Pyramid Volume
Pyramid Volume
Pyramid Surface
Pyramid Surface
Cone Volume
Cone Volume
Cone Surface Area
Cone Surface Area
Frustum Volume
Frustum Volume
Frustum Surface Area
Frustum Surface Area
Pipe Volume
Pipe Volume
Capsule Volume
Capsule Volume
Capsule Surface Area
Capsule Surface Area
Date and time calculators
Age Calculator
Age Calculator
Days Between Dates
Days Between Dates
Date Calculator
Date Calculator
Hours From Now
Hours From Now
Day of the Week
Day of the Week
Time Calculator
Time Calculator
Time Zone Converter
Time Zone Converter
Hours Calculator
Hours Calculator
Time Duration
Time Duration
Time Card
Time Card
Finance and economics calculators
Compound Interest
Compound Interest
Simple Interest
Simple Interest
Interest Calculator
Interest Calculator
TVM Calculator
TVM Calculator
Present Value
Present Value
Future Value
Future Value
ROI Calculator
ROI Calculator
IRR Calculator
IRR Calculator
Payback Period
Payback Period
Average Return
Average Return
GDP Calculator
GDP Calculator
Web marketing and ad metric calculators
CTR Calculator
CTR Calculator
Conversion Rate
Conversion Rate
CPC, CPM & CPA
CPC, CPM & CPA
ROAS Calculator
ROAS Calculator
Break-Even CPA
Break-Even CPA
LTV Calculator
LTV Calculator
CAC Calculator
CAC Calculator
Churn Rate
Churn Rate
A/B Test Calc
A/B Test Calc
A/B Sample Size
A/B Sample Size
SEO Traffic
SEO Traffic
Break-Even Point
Break-Even Point
Markup vs. Margin
Markup vs. Margin
CAGR Calculator
CAGR Calculator
Health and fitness calculators
BMI Calculator
BMI Calculator
Sleep Calculator
Sleep Calculator
Calorie Calculator
Calorie Calculator
BMR Calculator
BMR Calculator
TDEE Calculator
TDEE Calculator
Ideal Weight
Ideal Weight
Body Fat Calculator
Body Fat Calculator
Lean Body Mass
Lean Body Mass
Calories Burned
Calories Burned
Protein Intake
Protein Intake
Macro Calculator
Macro Calculator
Carb Calculator
Carb Calculator
Fat Intake
Fat Intake
Child Height
Child Height
Sports calculators
Golf Handicap
Golf Handicap
Pace Calculator
Pace Calculator
1RM Calculator
1RM Calculator
Target Heart Rate
Target Heart Rate
Weather calculators
Heat Index
Heat Index
Wind Chill
Wind Chill
Dew Point
Dew Point
Computer calculators
Base Converter
Base Converter
Subnet Calculator
Subnet Calculator
Download Time
Download Time
Household energy and budget calculators
Electricity Cost
Electricity Cost
kWh to Cost
kWh to Cost
Yearly kWh to Cost
Yearly kWh to Cost
AC Size (BTU)
AC Size (BTU)
AC Running Cost
AC Running Cost
Heating Costs
Heating Costs
Gas vs Electric
Gas vs Electric
LED Savings
LED Savings
Salary Calculator
Salary Calculator
Budget Calculator
Budget Calculator
Car calculators
Trip Gas Cost
Trip Gas Cost
EV Charging Cost
EV Charging Cost
EV vs Gas Cost
EV vs Gas Cost
MPG Calculator
MPG Calculator
Tire Size
Tire Size
Solar power and battery calculators
Solar Output
Solar Output
Solar Panel Count
Solar Panel Count
Solar Payback
Solar Payback
Battery Size
Battery Size
Home and DIY calculators
Tile Calculator
Tile Calculator
Stair Calculator
Stair Calculator
Concrete Volume
Concrete Volume
Wall Area
Wall Area
Wallpaper Rolls
Wallpaper Rolls
Paint Calculator
Paint Calculator
Flooring Needed
Flooring Needed
Exterior Walls
Exterior Walls
Gravel Needed
Gravel Needed
Mortar Mix
Mortar Mix
Slope Grade
Slope Grade
Lumber Cut List
Lumber Cut List
Lot Coverage/FAR
Lot Coverage/FAR
Sheet Vinyl Roll
Sheet Vinyl Roll
Insulation Needed
Insulation Needed
Curtain Size
Curtain Size
TV Size & Distance
TV Size & Distance
Soil Needed
Soil Needed
Sod Needed
Sod Needed
Block Calculator
Block Calculator
Brick Calculator
Brick Calculator
Deck Materials
Deck Materials
Ramp Length
Ramp Length
Pilot Hole Size
Pilot Hole Size
Room Ventilation
Room Ventilation
Paint Thinning
Paint Thinning
Baseboard & Trim
Baseboard & Trim
Blind Size
Blind Size
Picture Hanging
Picture Hanging
Drain Slope
Drain Slope
Screw Calculator
Screw Calculator
Board Feet
Board Feet
Fence Calculator
Fence Calculator
Wood Shrinkage
Wood Shrinkage
Caulk Calculator
Caulk Calculator
Heat Loss
Heat Loss
Furniture Fit
Furniture Fit
Moving Boxes
Moving Boxes
Storage Capacity
Storage Capacity
Plywood Cuts
Plywood Cuts
Shelf Sag
Shelf Sag

Time Zone Converter (Time Difference Calculator)

Enter the date and time you want to convert and choose the "from" and "to" time zones. The date, time and day of the week in the "to" zone and the time difference are calculated.

Enter the time as "3:00 PM" or "3 PM" (seconds are optional, as in "3:00:30 PM"). The 24-hour clock, such as "15:00", works too. Daylight saving time is not applied.
Result
Enter a date and time in the fields on the left, choose the time zones and press "Calculate". The result will appear here.

What you can do on this page

  • Choose a date, a time and the "from" and "to" time zones, and you get the date, time and day of the week in the other zone right away
  • US Eastern (New York) to US Pacific (Los Angeles) is selected from the start, so a question like "What time is 3:00 PM in New York in Los Angeles?" takes one click
  • The result also shows the time difference between the two zones (such as −3 h) and the date and time in UTC (Coordinated Universal Time) along the way
  • Conversions that cross midnight, the end of a year or a leap day are handled correctly, just as on the calendar
  • A plain-language explanation of the formulas and copy-and-paste formulas for Excel, Google Sheets and Python are all on this page
This calculator converts between fixed UTC offsets and does not apply daylight saving time (DST). For places that use DST, the options show standard time (for the US: EST, CST, MST, PST and AKST). During DST (in the US, from the second Sunday in March to the first Sunday in November), local clocks are 1 hour ahead of standard time. To convert a summer time, pick the offset 1 hour later: New York in summer (EDT) is UTC−04:00 and Los Angeles in summer (PDT) is UTC−07:00.

What is this calculation used for?

Scheduling meetings across time zones (remote and global teams)

"What time is 10:00 AM in New York in Los Angeles?" It is 7:00 AM (a difference of −3 hours). When you set up a meeting with coworkers in other places, this conversion helps you find a time that falls within everyone's working hours. For a team in Tokyo, 9:00 AM in New York is 11:00 PM in Tokyo in winter (+14 hours).
Watch out for daylight saving time. From mid-March to early November, New York moves from UTC−5 to UTC−4, and the gap with Tokyo shrinks to 13 hours, because Japan does not change its clocks. During those months, choose UTC−04:00 for New York (EDT) instead.

Reading flight departure and arrival times

On a ticket, the departure time is the local time where you leave, and the arrival time is the local time where you land. A flight that leaves New York at 8:00 AM and lands in Los Angeles at 11:30 AM seems to take 3.5 hours, but it is really in the air for 6.5 hours, because Los Angeles is 3 hours behind.
Once you can convert local times, you can tell whether it is a good time to call home and plan when to sleep to deal with jet lag.

Converting live streams and sports broadcasts to your time

Events abroad are often announced in local time. A soccer match that kicks off at 3:00 PM in London (GMT) starts at 10:00 AM in New York (EST) and at 7:00 AM in Los Angeles (PST).
This helps when you set a recording or plan a late night or an early morning. Note that the US and the UK change their clocks on different dates (the US in mid-March and early November, the UK at the end of March and the end of October), so for a few weeks a year the gap between London and New York is 4 hours instead of 5.

Keeping in touch with family and friends abroad

To contact someone at a good time for them, you need to know right away what time it is there. For example, 9:00 PM on Monday in Los Angeles (PST) is already 2:00 PM on Tuesday in Tokyo.
Calculate the time difference once and remember a pattern such as "my evening is their next afternoon", and you will know good times to call without calculating every time.

Following world markets and news in your own time (finance and work)

The New York Stock Exchange trades from 9:30 AM to 4:00 PM Eastern Time, which is 6:30 AM to 1:00 PM Pacific Time. Eastern and Pacific switch to daylight saving time on the same days, so this 3-hour gap holds all year. Economic reports are also usually announced in Eastern Time, so for investing and international business this conversion is part of the daily routine.
Markets abroad are trickier. The London Stock Exchange opens at 8:00 AM London time, which is 3:00 AM in New York in winter, but the gap changes for a few weeks when only one side has switched its clocks. Checking the conversion by season is the practical habit.

Formula

Time zone conversion formula (two steps through UTC)
Standard notation (the usual math form)
\(U\) \(=\) \(T_1\) \(-\) \(Z_1\)
\(T_2\) \(=\) \(U\) \(+\) \(Z_2\)
In words (symbols replaced with words)
③ \(U\): date and time in UTC \(=\) ① \(T_1\): input date and time \(-\) ② \(Z_1\): "from" offset
⑤ \(T_2\): converted date and time \(=\) \(U\): date and time in UTC \(+\) ④ \(Z_2\): "to" offset
The formula in words
① Start with the \(T_1\): input date and time (local time in the "from" zone)
② subtract the \(Z_1\): "from" offset
③ to get the \(U\): date and time in UTC (Coordinated Universal Time)
④ then add the \(Z_2\): "to" offset
⑤ and you get the \(T_2\): converted date and time
Quick example
Converting 3:00 PM (15:00) on January 15 in New York (UTC−05:00, EST) to Los Angeles time (UTC−08:00, PST), working with the hours only
UTC (Jan 15, 20:00) \(=\) input (Jan 15, 15:00) \(-\) "from" offset (−5 hours)
converted (Jan 15, 12:00) \(=\) UTC (Jan 15, 20:00) \(+\) "to" offset (−8 hours)
\(15 - (-5) = 20\)
\(20 + (-8) = 12\)
Key idea
Every time zone in the world is defined by how many hours it is ahead of or behind UTC (Coordinated Universal Time). This amount is called the offset. So you first subtract the "from" offset to get back to UTC, the time shared by the whole world, and then add the "to" offset. These two steps work the same way for any pair of places. Put together, they make one formula: converted time = input time − "from" offset + "to" offset. If the result is earlier than 0:00, the date moves back to the previous day. If it is 24:00 or later, the date moves forward to the next day. (This calculator also handles the end of a month or year for you.) In the example, 3:00 PM in New York is noon (12:00) in Los Angeles on the same day.
Finding the time difference (subtracting the offsets)
Standard notation (the usual math form)
\(D\) \(=\) \(Z_2\) \(-\) \(Z_1\)
In words (symbols replaced with words)
③ \(D\): time difference \(=\) ① \(Z_2\): "to" offset \(-\) ② \(Z_1\): "from" offset
The formula in words
① Take the \(Z_2\): "to" offset
② subtract the \(Z_1\): "from" offset
③ and you get the \(D\): time difference
Quick example
The time difference from New York (UTC−05:00, EST) to Los Angeles (UTC−08:00, PST) is
time difference (−3 hours) \(=\) "to" offset (−8 hours) \(-\) "from" offset (−5 hours)
\((-8) - (-5) = -3\)
Key idea
A negative time difference means the "to" zone is behind (its clocks show an earlier time). A positive one means it is ahead. Los Angeles (−8) is 3 hours behind New York (−5), so 9:00 AM in New York is only 6:00 AM in Los Angeles. Going the other way, Tokyo (+9) is 14 hours ahead of New York in winter, so a Monday morning in Tokyo is still Sunday evening in New York. Offsets such as "+9" and "−5" are signed numbers, so keep the signs when you subtract. Subtracting a negative number is the same as adding: (−8) − (−5) = −8 + 5 = −3.
A time zone conversion has two basic steps: subtract the "from" offset to get back to UTC, then add the "to" offset. The time difference is one offset minus the other (\(Z_2 - Z_1\)). In places that use daylight saving time, remember that the local clock may be 1 hour ahead of this result during the summer months.

Symbols and terms

Symbols

\(T_1\) T sub 1 The input date and time, in the "from" time zone. The small number at the lower right is a subscript that tells the first and second values apart.
\(T_2\) T sub 2 The converted date and time in the "to" time zone. This is what the calculator finds in the end.
\(U\) U The date and time converted to UTC (Coordinated Universal Time). It is the halfway point of the conversion and the reference time shared by the whole world. U stands for "Universal".
\(Z_1\), \(Z_2\) Z sub 1, Z sub 2 The UTC offsets of the "from" zone (\(Z_1\)) and the "to" zone (\(Z_2\)). Each one is a signed value that tells how many hours and minutes that time zone is ahead of or behind UTC. (Example - New York in winter is −5 hours, Los Angeles in winter is −8 hours, Japan is +9 hours)
\(D\) D The time difference between the two zones. It is found as \(D = Z_2 - Z_1\). A negative value means the "to" zone is behind. D stands for "difference".

Terms

time zone An area that uses the same standard time. The contiguous United States has four time zones (Eastern, Central, Mountain and Pacific), with Alaska and Hawaii in their own zones. Russia has 11. China, although it is a very wide country, uses just one (UTC+8), and so does Japan (UTC+9).
UTC (Coordinated Universal Time) The reference time for the whole world, kept by atomic clocks. Every local time is written as how many hours it is ahead of or behind UTC. US Eastern Standard Time is 5 hours behind UTC, so it is "UTC−5".
GMT (Greenwich Mean Time) The time based on the Sun as observed at the Royal Observatory in Greenwich, England. The world standard is now UTC, which is based on atomic clocks, but the two are kept within 1 second of each other, so in everyday life they mean almost the same thing. The UK uses GMT in winter.
offset How many hours and minutes a time zone is ahead of or behind UTC, written like "UTC−05:00" or "UTC+09:00". Most offsets are whole hours, but some are not, such as India (+5:30) and Nepal (+5:45).
daylight saving time (DST) Setting the clocks 1 hour ahead during the summer, when days are long. In most of the US it runs from the second Sunday in March to the first Sunday in November, and the offset changes by 1 hour (New York goes from UTC−5 to UTC−4, which is EDT). Hawaii and most of Arizona do not use it. Europe switches on the last Sundays of March and October, so for a few weeks each year the gap between the US and Europe is 1 hour different from usual. This calculator does not apply DST.
International Date Line The line in the Pacific Ocean, roughly along 180° longitude, where the date changes. The date differs by about one day across it, so at the same moment a place at UTC−12 and a place at UTC+12 show clock times that are 24 hours (one full day) apart. If you convert from UTC−12:00 to UTC+12:00 in this calculator, the time difference is "+24 h". The clock time stays the same and only the date moves forward by one day.
standard time The official time a country or region uses outside daylight saving time. In the US, the main ones are Eastern (EST, UTC−5), Central (CST, UTC−6), Mountain (MST, UTC−7) and Pacific (PST, UTC−8). Each US zone is roughly 15° of longitude wide.

Good to know before you start

Here is what helps you use the calculation on this page with real understanding, not just by pressing the button.
If you get stuck, going back over these topics is the fastest way forward.

Telling time and the 24-hour clock (Grade 3 and up)
  • Knowing the difference between a time of day (a point in time, such as 3:00 PM) and a length of time (such as 9 hours)
  • Being able to rewrite AM and PM times on the 24-hour clock (0 to 23), such as 3:00 PM = 15:00
Elapsed time across midnight (Grades 3–4)
  • Being able to add and subtract hours on a clock, such as 15 + 5 = 20
  • Knowing that if the result is earlier than 0:00 the date moves back one day, and if it goes past 24:00 the date moves forward one day
Adding and subtracting negative numbers (Grade 7)
  • Being able to subtract signed numbers, such as (−8) − (−5) = −3
  • Picturing it on a number line - plus moves forward, minus moves back
Time zones and longitude (middle school geography)
  • Knowing that the Earth turns once in about 24 hours, so every 15° of longitude makes about 1 hour of time difference
  • Knowing that US Eastern Standard Time is UTC−5, based on 75° west longitude, and each US zone to the west is 1 hour earlier

How to calculate it in Excel

Copy the whole table below and paste it into cell A1 in Excel. It works as is.
Table for a time zone conversion (two steps through UTC)
Date 2026-01-15
Time 15:00:00
"From" offset (hours) -5
"To" offset (hours) -8
Date and time in UTC =B1+B2-B3/24
Converted date and time =B5+B4/24
Converted day of the week =TEXT(B6,"dddd")
Table for the time difference
"From" offset (hours) -5
"To" offset (hours) -8
Time difference (hours) =B2-B1
Inside Excel, dates and times are serial numbers where 1 day = 1. So you combine the date and time with "date + time", then divide each offset in hours by 24 before adding or subtracting it (cells B5 and B6 of the first table do this).
If B5 or B6 shows a number such as "46037.83333", change the cell format to the custom format "m/d/yyyy h:mm:ss". In the first table, the date and time in UTC is 1/15/2026 20:00:00, the converted date and time is 1/15/2026 12:00:00, and B7 shows the day of the week (Thursday). The answer in the second table is −3 (hours).
Enter offsets that are not whole hours as decimal hours: India (UTC+5:30) is "5.5" and Nepal (UTC+5:45) is "5.75" (30 minutes = 0.5 hours, 45 minutes = 0.75 hours). Just replace the values in column B with your own.

How to calculate it in Google Sheets

Copy the whole table below and paste it into cell A1 in Google Sheets. It works as is.
Table for a time zone conversion (two steps through UTC)
Date 2026-01-15
Time 15:00:00
"From" offset (hours) -5
"To" offset (hours) -8
Date and time in UTC =B1+B2-B3/24
Converted date and time =B5+B4/24
Converted day of the week =TEXT(B6,"dddd")
Table for the time difference
"From" offset (hours) -5
"To" offset (hours) -8
Time difference (hours) =B2-B1
The same formulas as in Excel work as is. Copy the whole table, paste it into cell A1, and replace the values in column B with your own.
=TEXT(B6,"dddd") shows the full name of the day of the week (Thursday). If a result appears as a number (a serial value), change it to a date and time with "Format → Number → Date time" in the menu.

How to calculate it in Python

from datetime import datetime, timedelta

input_datetime = datetime(2026, 1, 15, 15, 0, 0)  # date and time in the "from" zone (year, month, day, hour, minute, second)
from_offset = timedelta(hours=-5)                 # "from" offset (US Eastern, standard time, UTC-05:00)
to_offset = timedelta(hours=-8)                   # "to" offset (US Pacific, standard time, UTC-08:00)

utc_datetime = input_datetime - from_offset       # step 1: convert to UTC (Coordinated Universal Time)
converted_datetime = utc_datetime + to_offset     # step 2: convert to the "to" zone
diff_hours = (to_offset - from_offset).total_seconds() / 3600  # time difference between the two zones

weekday_names = ['Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday']
print(f"Date and time in UTC: {utc_datetime:%m/%d/%Y %H:%M:%S}")
print(f"Converted date and time: {converted_datetime:%m/%d/%Y %H:%M:%S} ({weekday_names[converted_datetime.weekday()]})")
print(f"Time difference: {diff_hours:+.2f} hours")
Runs with the standard library only. A timedelta is an object that stores a length of time. Subtract it from a datetime to get UTC, and add it to get the time in the "to" zone. Python follows the calendar for you, so crossing midnight, the end of a year and leap years are all handled correctly. Offsets that are not whole hours, such as India (UTC+5:30), can be written as timedelta(hours=5, minutes=30). Change the date and time and the two offsets at the top, then run the code.

How to write it in LaTeX and other math languages (copy and paste)

Time zone conversion formula (two steps through UTC)
U = T₁ − Z₁,  T₂ = U + Z₂
U = T_1 - Z_1, \quad T_2 = U + Z_2
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
  <mrow>
    <mi>U</mi><mo>=</mo>
    <msub><mi>T</mi><mn>1</mn></msub><mo>&#x2212;</mo>
    <msub><mi>Z</mi><mn>1</mn></msub>
    <mo>,</mo><mspace width="0.7em"/>
    <msub><mi>T</mi><mn>2</mn></msub><mo>=</mo>
    <mi>U</mi><mo>+</mo>
    <msub><mi>Z</mi><mn>2</mn></msub>
  </mrow>
</math>
U = T_1 - Z_1, T_2 = U + Z_2
TimeZoneConvert[DateObject[{2026, 1, 15, 15, 0, 0}, TimeZone -> -5], -8]
U := T1 - Z1; T2 := U + Z2;
t = datetime(2026,1,15,15,0,0,'TimeZone','-05:00'); t.TimeZone = '-08:00';
U = T_1 - Z_1, T_2 = U + Z_2
Finding the time difference (subtracting the offsets)
D = Z₂ − Z₁
D = Z_2 - Z_1
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
  <mrow>
    <mi>D</mi><mo>=</mo>
    <msub><mi>Z</mi><mn>2</mn></msub><mo>&#x2212;</mo>
    <msub><mi>Z</mi><mn>1</mn></msub>
  </mrow>
</math>
D = Z_2 - Z_1
d = z2 - z1
D_diff := Z2 - Z1;
d = z2 - z1;
D = Z_2 - Z_1

How to have ChatGPT  do the calculation

You are a time zone calculation assistant. Do the following calculation by actually running Python code, and base your answer only on the date and time from the execution result (do not answer by mental math or guessing).

Convert 3:00:00 PM (15:00:00) on January 15, 2026 in US Eastern Standard Time (UTC−05:00) to US Pacific Standard Time (UTC−08:00). Treat both as fixed offsets (do not apply daylight saving time). Use two steps: subtract the "from" offset from the input date and time to get UTC, then add the "to" offset to UTC. If the date changes, follow the calendar.

Show the date and time in UTC along the way, the converted date and time (24-hour clock) and day of the week, and the time difference between the two zones.

How to Use
  1. 1
    Enter your numbers
    Type the numbers you want to calculate with into the input fields
  2. 2
    Calculate
    Press the "Calculate" button
  3. 3
    Check the result
    The result appears on the spot. The same page also explains the idea behind the calculation and the formula
  DataChef Features
Easy and Free
Unlimited conversions for free.
No technical knowledge required.
Intuitive and user-friendly operation.
No Registration Required
Available immediately after access.
Can be used without registering personal information.
Safe and Secure
Fully SSL encrypted communication.
Automatic file deletion by clicking "download".
Fast
High-speed site access
and rapid file conversion.
No Watermark
No watermark.
No attribution required.
Commercial Use Available
Free for commercial use.
No need to contact us for commercial use permission.