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 24, 2022 in Database by Edureka
 • 13,690 points • 2,203 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 25, 2022 by gaurav
 • 23,260 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, 2022 in Database by Edureka
 • 13,690 points • 20,227 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, 2022 in Database by gaurav
 • 23,260 points • 969 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, 2022 in Database by gaurav
 • 23,260 points • 5,344 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, 2022 in Database by Edureka
 • 13,690 points • 2,165 views
0 votes
1 answer

How to count distinct values in Excel

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

answered Mar 15, 2022 in Database by gaurav
 • 23,260 points • 1,501 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, 2022 in Database by gaurav
 • 23,260 points • 2,177 views
0 votes
1 answer

EXCEL: How to automatically add serial number in Excel Table using formula that is immune to filtering / sorting?

That's a great question, and it's a ...READ MORE

answered Mar 24, 2022 in Database by gaurav
 • 23,260 points • 2,314 views
0 votes
1 answer

EXCEL: How to automatically add serial number in Excel Table using formula that is immune to filtering / sorting?

These techniques can add a running column ...READ MORE

answered Mar 24, 2022 in Database by gaurav
 • 23,260 points • 1,995 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 30, 2022 in Database by gaurav
 • 23,260 points • 11,649 views
0 votes
1 answer

How to convert date to general in excel without losing format?

The steps are as follows: Copy the dates ...READ MORE

answered Apr 1, 2022 in Database by gaurav
 • 23,260 points • 42,314 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
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.