hsg,

Enter the following formula in b1:

=A1-((1/24)*5.5)

Then highlight all the cells you want to appear as 00:00

Go to Format Cells (Ctrl+1) and select custom. From there, type in hh:mm.

In order for this to work you must enter a full date plus the time e.g.
2/26/2010 6:00 AM. When you format it as hh:mm the date goes away but is
still available to calculate back a day.

HTH.

"hsg" wrote:

I need to display time in two cells in different format

a1 = indian standard time
b1=corresponding GMT

example: a1=06:00 then b1=00:30 (IST = +5:30 GMT)
a1=02:00 then b1=20:30

Is there a formula which will do the trick?

Furthermore, I want to enter IST in cell A1 by simply entering 0600 or 0200,
can this be automatically
formatted to display 06:00 or 02:00?