I have to convert utc time to ist in excel

0 votes
I have to convert utc time to ist time in my excel the the time format is 10:00:00 utc this has to converted in IST timing. Please suggested
Apr 4 in Database by gaurav
• 13,560 points
902 views

1 answer to this question.

0 votes

There are no built-in functions for determining and converting timezones. To fix this problem, we can enhance the capabilities of the Excel Time() function.

=A1+Time(5,30,0)

You'll need to add 5 hours and 30 minutes for IST. Similarly, by adding or removing the time difference, you can convert to any timezone.

Hours, minutes, and seconds are the three inputs to Time().

This function returns a serial number formatted timestamp. This number will be interpreted by Excel, and the timestamp will be displayed in a legible format.

answered Apr 4 by Edureka
• 13,640 points

Related Questions In Database

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
• 13,560 points
60 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 in Database by gaurav
• 13,560 points
264 views
0 votes
1 answer

I have a Run Time Error 91 for an Excel Add In

"Runtime Error 91: Object variable or with ...READ MORE

answered Mar 30 in Database by gaurav
• 13,560 points
245 views
0 votes
1 answer

I have a Run Time Error 91 for an Excel Add In

When there was no unhidden workbook open ...READ MORE

answered Apr 6 in Database by gaurav
• 13,560 points
58 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
• 13,560 points
44 views
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
• 13,560 points
84 views
0 votes
1 answer

Convert Date to Text without losing the format in Excel?

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

answered Apr 1 in Database by gaurav
• 13,560 points
400 views
0 votes
1 answer

Can I have multiple primary keys in a single table?

A Table can have a Composite Primary Key which ...READ MORE

answered Oct 25, 2018 in Database by Frankie
• 9,830 points
2,387 views
0 votes
1 answer

How to transform multiple tables in one excel sheet to one table with Power BI?

If my prediction is correct- You have a ...READ MORE

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

How to enter a series of numbers automatically in Excel

Excel, unlike other Microsoft Office programmes, does ...READ MORE

answered Apr 4 in Database by Edureka
• 13,640 points
25 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP