how to Convert EST time to IST time in excel

0 votes
I have a requirement where I get the data in Excel column like "7/12/2017 3:00:00 AM" (EST timing). Now I need to convert it into IST time of the same format.
Mar 25 in Database by Edureka
• 13,640 points
1,641 views

1 answer to this question.

0 votes

Use the following calculation since Indian Standard Time is 9 hours and 30 minutes ahead of Eastern Time.

=A1+TIME(9,30,0)
enter image description here
answered Mar 30 by gaurav
• 22,040 points

Related Questions In Database

0 votes
1 answer

I have to convert utc time to ist in excel

There are no built-in functions for determining ...READ MORE

answered Apr 4 in Database by Edureka
• 13,640 points
4,171 views
0 votes
1 answer

How to sort dates from Oldest to Newest in Excel?

Drag down the column to select the ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
412 views
0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24 in Database by Edureka
• 13,640 points
769 views
0 votes
1 answer

How to count distinct values in Excel

Use functions to count the number of ...READ MORE

answered Mar 15 in Database by gaurav
• 22,040 points
517 views
0 votes
1 answer

[Excel][VBA] How to draw a line in a graph?

Sub MakeChart() Dim x(20) ...READ MORE

answered Mar 24 in Database by gaurav
• 22,040 points
381 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Convert numbers to words in Excel (VBA)

In the cell where you wish to ...READ MORE

answered Mar 25 in Database by gaurav
• 22,040 points
1,709 views
0 votes
1 answer

how to Convert EST time to IST time in excel?

Use the following calculation since Indian Standard ...READ MORE

answered Mar 25 in Database by gaurav
• 22,040 points
343 views
0 votes
1 answer

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
140 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP