Hello-- I have an export of data which is a list of details on support tickets opened. One column is a list of times in GMT form of HH:MM am/pm. I need to convert these to MST which is 7 hours less. When I do this formula, D2-TIME(7,0,0) it works for all cells except those times that are earlier than 6:59. In those cases it give an error of continual ####### signs. How do I overcome this and have a time of 2:45 am (GMT) change to 7:45 pm (MST).
here are some examples
Excel Forum example.xls
mrteater,
Try adding a 1 to it, which adds a whole day so that it doesn't affect the time of day, and prevents negative times which causes the ###### signs:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi mrteater
Try: =MOD(G2-TIME(7,0,0),1)
Regards Kevin
Merged Cells (They are the work of the devil!!!)
That worked perfectly-- Thank you
That works too--Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks