How convert GMT into IST in excel?

Indian Standard Time is 5 hours and 30 minutes ahead of Greenwich Mean Time. In winter this is 6 hours and 30 minutes, while daylight savings time is in operation So to convert you have to add the time difference to the original time. In a cell type the GMT you want.So if it was 10:30am, in the appropriate cell you could type: 10:30 In another cell you would put the time difference: 5:30 You then need to add the two together.

If the GMT value was in cell B2 and the time difference was in C2, then in another cell you would have the formula: B2+C2 You may need to reformat the cell to show the time the exact way you want. This can be done by going to the Format menu, picking Cells, and then Time and finally the format you want the time to show as.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions