Stock Last Trade time are not matching with current Indian Time

Question

Stock Last Trade time are not matching with current Indian Time

swaroop kodande 20

I try to use the Date - Stock option to get the current price of the stock & Last Trade Time, but in the Excel sheet, it shows wrong timing in different regions. Kindly provide the procedure to correct it

User's image

0 comments

Answer accepted by question author

1 additional answer

Your answer

Answer 1

Kal-D 7,265 Microsoft External Staff Moderator

Hi swaroop kodande,

What you’re seeing is mainly a time zone difference, not an issue with the stock price field itself.

In Excel’s Stocks data type, Last Trade Time is often returned as a neutral/UTC‑based timestamp, while your Current Time column reflects your Mac’s local system time. Because the timestamp isn’t automatically localized, it can appear “off” unless you convert it.

From your screenshot:

Last Trade Time: 30 Mar 26 07:55 AM
Current Time: 30 Mar 26 01:41 PM

If 07:55 AM is treated as UTC, adding 5 hours 30 minutes converts it to 01:25 PM IST, which is much closer to your local time. Any remaining difference is typically due to normal data refresh intervals and exchange reporting delays.

How to correct it in Excel for Mac

Keep the original Last Trade Time value, and convert it in a separate column:

For India (IST): =E2+TIME(5,30,0) or =E2+5.5/24

Then format the result as: dd mmm yy hh:mm AM/PM

Notes:

This offset is specific to IST, so it would need adjustment if the file is opened in another region.
Refreshing the Stocks data is still useful, but it won’t automatically correct the time zone.
After adding the formula, refresh the stock data so the converted time reflects the latest update.

Please let me know if this proves useful to you, or if you would like further assistance.

I'm looking forward to your reply.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment”.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Kal-D 7,265 Reputation points Microsoft External Staff Moderator

2026-03-31T22:56:17.4733333+00:00

Hi swaroop kodande,

It's been a while so I am curious to see how things are going with this issue.

If there’s anything else I can assist you with or if you need further clarification, please don’t hesitate to let me know, I’m here to help.

Looking forward to your reply.
swaroop kodande 20 Reputation points

2026-04-01T13:46:40.5466667+00:00

Thank you, Is there any option to update the time as per the current time, is there any setting for this
Kal-D 7,265 Reputation points Microsoft External Staff Moderator

2026-04-01T19:14:11.84+00:00

Hi swaroop kodande,

Thank you for checking.

At the moment, there is no Excel setting or option to automatically adjust the Stocks “Last Trade Time” to your local time zone. The timestamp returned by the Stocks data type is not dynamically localized based on system or regional settings.

To display the time in your local zone, the only supported approach is to apply a conversion formula in another column (for example, adding the IST offset). This behavior is consistent with how Excel has historically returned stock timestamps, which are provided in a neutral/UTC‑based time and left unchanged by regional settings.

Refreshing the stock data will update the value itself, but it won’t change the time zone representation, so the conversion formula is still required.

Answer 2

swaroop kodande 20

Thank you,
Is there any option to update the time as per the current time, is there any setting for this

0 comments

Share via

Stock Last Trade time are not matching with current Indian Time

1 additional answer

Your answer