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

2

1 Answer

There are no inbuilt functions that identify/convert the timezones. We can extend the capabilities of Excel Time() function to solve this use case.

=A1+Time(5,30,0)

For IST, you will have to add 5 hours and 30 minutes. Similarly, you can convert to any timezone by adding/subtracting the time difference.

The three inputs given to the Time() are hours,minutes and seconds.

This function returns the timestamp in a serial number format. Excel will interpret this number and show the timestamp in a readable format.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy