=NOW()

will give you the current time of your computer clock
if you put NOW() in A1 and format it as time

simply subtract or add the different timezones

=MOD(A1-TIME(5,,),1)

the above will give you STD us east coast time when now() is Greenwich or if
you are on the east coast and
friend is in Seattle you would get his/her time

=MOD(A1-TIME(3,,),1)

so you need to use some sort of lookup table with your friends names and
their respective +- time

so if you create a 2 column table with names in the leftmost column and
their time offset in column2 with -3 for
Seattle if your times zone is US eastern

=MOD(A1+VLOOKUP(A3,MyTable,2,0)*TIME(1,,),1)



--
Regards,

Peo Sjoblom

(No private emails please)


"SammyJJones" wrote in message
...

Ok, you guys helped be out big time with my last question!!! So here's
another.

I want A1 to = the current time (where I am)
B1 = Friends name
C1 = time diff in hours between us
D1 = What time it is where they are.


Is this possible???


Thanks in advance,
Sammy


--
SammyJJones