Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Make A Universal Time Converter
I would like a time converter, that would allow me to convert Universal time,
into PST. I am doing a project where the phases of the moon are time in Universal Time (GMT). We are -8 hours West of UT. I have tried several ways to come up with a formula, and am unable to get a valid response. |
#2
|
|||
|
|||
One way:
XL stores times as fractional days, so if UT is in A1, use B1: =A1 - TIME(8,0,0) or B1: =A1 - 8/24 or =A1 - 1/3 Format B1 as a time, if necessary. In article , " om wrote: I would like a time converter, that would allow me to convert Universal time, into PST. I am doing a project where the phases of the moon are time in Universal Time (GMT). We are -8 hours West of UT. I have tried several ways to come up with a formula, and am unable to get a valid response. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |