formula for local time and GMT?

[hsg]

I would like to display time in LOCAL time as well as GMT.
Whenever LOCAL time is entered in A1, B1 should automatically
display GMT. Both cells to use format HH:MM.
Specifically local time is +5.50 GMT, but general formula
will be appreciated. thanx

 

[Roger Govier]

Hi

Time is stored as fractions of a day (24 hours) so GMT=Localtime-5.5/24
In B1
=IF(A1="","",A1-5.5/24)

--
Regards
Roger Govier

I would like to display time in LOCAL time as well as GMT.
Whenever LOCAL time is entered in A1, B1 should automatically
display GMT. Both cells to use format HH:MM.
Specifically local time is +5.50 GMT, but general formula
will be appreciated. thanx

__________ Information from ESET Smart Security, version of virus
signature database 4756 (20100109) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________

The message was checked by ESET Smart Security.

http://www.eset.com