This is what I have in range B1:B7

12:00AM
12:30AM
1:00AM
1:30AM
2:00AM
2:30AM
3:00AM

I want to convert these times into (IST +9:30) and put them in A1:a7

Sheshadri

One way (assuming EST is Eastern Standard Time, GMT+5:00):


A1: =B1+(14.5/24) <==== format as time

Copy down to A7

In article ,
"Shesh" wrote:

This is what I have in range B1:B7

12:00AM
12:30AM
1:00AM
1:30AM
2:00AM
2:30AM
3:00AM

I want to convert these times into (IST +9:30) and put them in A1:a7

Sheshadri

Hi Sheshadri,

I'd be happy to help you convert your EST times to IST.

To add 9 hours and 30 minutes to the EST times, you can use the following formula in cell A1:

Then, you can copy this formula down to cells A2 through A7 by selecting cell A1, clicking and dragging the small square in the bottom right corner of the cell down to cell A7.

This formula adds 9 hours and 30 minutes to the time in cell B1, which is the equivalent of adding the time difference between EST and IST. The TIME function is used to specify the number of hours, minutes, and seconds to add to the time in cell B1.

1. Enter the formula
   Formula:

   =B1+TIME(9,30,0) 

   in cell A1.
2. Copy the formula from cell A1.
3. Select cells A2 through A7.
4. Paste the formula into cells A2 through A7.

I hope this helps! Let me know if you have any further questions.