Good morning. I have a column containing date and time (UTC) in this format (yyyy-mm-dd hh:mm:ss). I need to convert it to the same format but in MST time zone. The column contains more than a hundred cells so converting manually is too time consuming and I foresee doing this task multiple times. Can someone provide a formula to convert that? Thank you for any help.
If A1 is a date value with the UTC time, try:
=A1-5/24
The answer to your question also depends on the exact format of the UTC date.
Here is one example:
Formula:
Please Login or Register to view this content.
Cell formatted as Custom, m/d/yyyy h:mm AM/PM
to get MST time deduct -"2:00"
Data Range
Last edited by AlKey; 11-09-2015 at 01:58 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks