LinkBack URL
About LinkBacks
eg:
"A" column is in CET timezone
How to change A column's time to Chinese timz one (GMT +8, CET +6)
BTW, do I need to change the cell to specific attrubite,eg: date, time, etc?
Thanks in advance!
eg:
"A" column is in CET timezone
How to change A column's time to Chinese timz one (GMT +8, CET +6)
BTW, do I need to change the cell to specific attrubite,eg: date, time, etc?
Thanks in advance!
Last edited by littlebaggio; 09-02-2013 at 11:25 PM.
Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Please check attached file.
Hope I made my question clearly.
If Column-A Data is real date / Time then in
B2 Cell
Formula:
=IF(A2="","",A2+TIME(6,0,0))
Drag it down..
To 6th sense
It doesn't work with "#Value!".
Please help check it. Thanks a lot!
What is your date setting in Control Panel? If it is in MM-DD-YYYY then it will work.
It was resolved by "6thsense"!
How to change the title of it to "Resolved"?
You have already changed the status as Solved
Glad it helps you and thanks for the feedback and rep
Oopss.. Just interchange the data and time if needed.
Formula:dd/mm/yyyy hh:mm:ss
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks