Converting GMT to PST

H

hunter5

New Member
Joined
Feb 10, 2011
Messages
6
Hello!

I'm interpreting data collected from an underwater sensor, and have to convert time (hr:mn:sc) taken every minute, from GMT to PST(GMT-8:00). Please help!

Thank you,
hunter5
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Sort by date Sort by votes
Hi and welcome.


If A1 has your GMT time...

=A1-8/24

This subtracts eight hours from the time in cell A1. Remember to format the cell with this formula as Time.
 
Last edited:
Upvote 0
If you only have a time in A1 then you'll get an error with that formula if A1 is < 08:00. To fix that try

=MOD(A1-8/24,1)
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
Need small fix to previous UTC post
Replies
0
Views
435
jdellasala
J
T
  • Question
Help with Date and Time Formula to combine date and time UTC and then convert to PST
Replies
2
Views
1K
tbruce
T
T
  • Question
Get internet time for mac
Replies
0
Views
344
tiredofit
T
M
  • Question
I need help with VBA/macro script to collect user input and fill cells
Replies
4
Views
379
mumps
mumps
W
  • Question
Calculate total time taken to complete task in working days (6am to 6pm)
Replies
4
Views
329
Wibab
W

Forum statistics

Threads
1,221,250
Messages
6,158,817
Members
451,517
Latest member
Maithreya

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top