• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

convert MST to IST with date and time

S

saravana

New Member
Hi,

I need to convert date and time from MST to IST,

please help me on this.
 

Attachments

  • sample excel.xlsx
    15.4 KB · Views: 3
In G2 copied down:

=A2+"11:30"

Select column G and set the cell formatting to custom: dd/mm/yyyy hh:mm
 

Attachments

  • MST to IST.xlsx
    14.7 KB · Views: 2
You must log in or register to reply here.
Back
Top