Server time from Local Time
 

I play on a games server that uses the 24 hour clock for reporting. Issue is
I'm 6 hours behind server time. I would like to have my real time calculated
after I enter my server reports into the spreadsheet. One column is fine for
the server time of the report but would like a real time column so I can get
a handle on exactly when the reports were generated in my time.

Second item is I'm given a date. Is there a formula that can give me the day
of the week based of off the server date? 5/15/09 = Sunday

Only complication I'll have is when teh real time isn't the same day of the
week that the report was generated. Will need to be consious on the count
back I may roll back a day.

So I get the following........
01:01:00 5/15/09

but I'm 6 hours before server time. Need to convert teh above to my real
time and real date.

Thanks

Server time from Local Time
 

So I get the following........
01:01:00 5/15/09
but I'm 6 hours before server time

A1 = 01:01:00
B1 = 5/15/09

=A1+B1+TIME(6,0,0)

Custom format as dddd m/d/yy h:mm:ss

--
Biff
Microsoft Excel MVP


"jaxstraww" wrote in message
...
I play on a games server that uses the 24 hour clock for reporting. Issue
is
I'm 6 hours behind server time. I would like to have my real time
calculated
after I enter my server reports into the spreadsheet. One column is fine
for
the server time of the report but would like a real time column so I can
get
a handle on exactly when the reports were generated in my time.

Second item is I'm given a date. Is there a formula that can give me the
day
of the week based of off the server date? 5/15/09 = Sunday

Only complication I'll have is when teh real time isn't the same day of
the
week that the report was generated. Will need to be consious on the count
back I may roll back a day.

So I get the following........
01:01:00 5/15/09

but I'm 6 hours before server time. Need to convert teh above to my real
time and real date.

Thanks

Server time from Local Time
 

Hmmm...

I think I have it backwards!

If you're 6 hrs behind instead of adding 6 hrs, subtract 6 hrs:

=A1+B1-TIME(6,0,0)

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
So I get the following........
01:01:00 5/15/09
but I'm 6 hours before server time

A1 = 01:01:00
B1 = 5/15/09

=A1+B1+TIME(6,0,0)

Custom format as dddd m/d/yy h:mm:ss

--
Biff
Microsoft Excel MVP


"jaxstraww" wrote in message
...
I play on a games server that uses the 24 hour clock for reporting. Issue
is
I'm 6 hours behind server time. I would like to have my real time
calculated
after I enter my server reports into the spreadsheet. One column is fine
for
the server time of the report but would like a real time column so I can
get
a handle on exactly when the reports were generated in my time.

Second item is I'm given a date. Is there a formula that can give me the
day
of the week based of off the server date? 5/15/09 = Sunday

Only complication I'll have is when teh real time isn't the same day of
the
week that the report was generated. Will need to be consious on the count
back I may roll back a day.

So I get the following........
01:01:00 5/15/09

but I'm 6 hours before server time. Need to convert teh above to my real
time and real date.

Thanks

Server time from Local Time
 

Many thanks but the (6) is putting me ahead 6 hours. I need it to read 6
hours behind. I tried (-6) but get an "NUM" error?

"T. Valko" wrote:

So I get the following........
01:01:00 5/15/09
but I'm 6 hours before server time

A1 = 01:01:00
B1 = 5/15/09

=A1+B1+TIME(6,0,0)

Custom format as dddd m/d/yy h:mm:ss

--
Biff
Microsoft Excel MVP


"jaxstraww" wrote in message
...
I play on a games server that uses the 24 hour clock for reporting. Issue
is
I'm 6 hours behind server time. I would like to have my real time
calculated
after I enter my server reports into the spreadsheet. One column is fine
for
the server time of the report but would like a real time column so I can
get
a handle on exactly when the reports were generated in my time.

Second item is I'm given a date. Is there a formula that can give me the
day
of the week based of off the server date? 5/15/09 = Sunday

Only complication I'll have is when teh real time isn't the same day of
the
week that the report was generated. Will need to be consious on the count
back I may roll back a day.

So I get the following........
01:01:00 5/15/09

but I'm 6 hours before server time. Need to convert teh above to my real
time and real date.

Thanks

Server time from Local Time
 

Ha. I posted before I refreshed. Yes it was backwards. Thanks again. Much help.

"T. Valko" wrote:

Hmmm...

I think I have it backwards!

If you're 6 hrs behind instead of adding 6 hrs, subtract 6 hrs:

=A1+B1-TIME(6,0,0)

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
So I get the following........
01:01:00 5/15/09
but I'm 6 hours before server time

A1 = 01:01:00
B1 = 5/15/09

=A1+B1+TIME(6,0,0)

Custom format as dddd m/d/yy h:mm:ss

--
Biff
Microsoft Excel MVP


"jaxstraww" wrote in message
...
I play on a games server that uses the 24 hour clock for reporting. Issue
is
I'm 6 hours behind server time. I would like to have my real time
calculated
after I enter my server reports into the spreadsheet. One column is fine
for
the server time of the report but would like a real time column so I can
get
a handle on exactly when the reports were generated in my time.

Second item is I'm given a date. Is there a formula that can give me the
day
of the week based of off the server date? 5/15/09 = Sunday

Only complication I'll have is when teh real time isn't the same day of
the
week that the report was generated. Will need to be consious on the count
back I may roll back a day.

So I get the following........
01:01:00 5/15/09

but I'm 6 hours before server time. Need to convert teh above to my real
time and real date.

Thanks

Server time from Local Time
 

Again, issue closed. Somehow an earlier reply became the later reply......

"jaxstraww" wrote:

Many thanks but the (6) is putting me ahead 6 hours. I need it to read 6
hours behind. I tried (-6) but get an "NUM" error?

"T. Valko" wrote:

So I get the following........
01:01:00 5/15/09
but I'm 6 hours before server time

A1 = 01:01:00
B1 = 5/15/09

=A1+B1+TIME(6,0,0)

Custom format as dddd m/d/yy h:mm:ss

--
Biff
Microsoft Excel MVP


"jaxstraww" wrote in message
...
I play on a games server that uses the 24 hour clock for reporting. Issue
is
I'm 6 hours behind server time. I would like to have my real time
calculated
after I enter my server reports into the spreadsheet. One column is fine
for
the server time of the report but would like a real time column so I can
get
a handle on exactly when the reports were generated in my time.

Second item is I'm given a date. Is there a formula that can give me the
day
of the week based of off the server date? 5/15/09 = Sunday

Only complication I'll have is when teh real time isn't the same day of
the
week that the report was generated. Will need to be consious on the count
back I may roll back a day.

So I get the following........
01:01:00 5/15/09

but I'm 6 hours before server time. Need to convert teh above to my real
time and real date.

Thanks

Server time from Local Time
 

Good deal. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"jaxstraww" wrote in message
...
Ha. I posted before I refreshed. Yes it was backwards. Thanks again. Much
help.

"T. Valko" wrote:

Hmmm...

I think I have it backwards!

If you're 6 hrs behind instead of adding 6 hrs, subtract 6 hrs:

=A1+B1-TIME(6,0,0)

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
So I get the following........
01:01:00 5/15/09
but I'm 6 hours before server time

A1 = 01:01:00
B1 = 5/15/09

=A1+B1+TIME(6,0,0)

Custom format as dddd m/d/yy h:mm:ss

--
Biff
Microsoft Excel MVP


"jaxstraww" wrote in message
...
I play on a games server that uses the 24 hour clock for reporting.
Issue
is
I'm 6 hours behind server time. I would like to have my real time
calculated
after I enter my server reports into the spreadsheet. One column is
fine
for
the server time of the report but would like a real time column so I
can
get
a handle on exactly when the reports were generated in my time.

Second item is I'm given a date. Is there a formula that can give me
the
day
of the week based of off the server date? 5/15/09 = Sunday

Only complication I'll have is when teh real time isn't the same day
of
the
week that the report was generated. Will need to be consious on the
count
back I may roll back a day.

So I get the following........
01:01:00 5/15/09

but I'm 6 hours before server time. Need to convert teh above to my
real
time and real date.

Thanks