Thursday, March 22, 2012

Converting time zones in Excel.

If you have one column (C) in Excel with a list of date time values (PST) and want to have another column (D) in Excel that should show IST, you can use the following formula in the column D.

= C1 + TIMEVALUE("12:30")
at No comments:
Labels:
Subscribe to: Comments (Atom)

What is success?

The journey of life takes us through varied experiences like landing an admission at a prestigious college, earning a degree, getting hired,...