LinkBack URL
About LinkBacks
Hello All,
Please help me in converting attached texted date and time format to excel readable date and time format.
Will appreciate and grateful if you could help me out with the formula to convert the same
Date and Time Format.JPG
Hello All,
Please help me in converting attached texted date and time format to excel readable date and time format.
Will appreciate and grateful if you could help me out with the formula to convert the same
Date and Time Format.JPG
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. 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 shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
If posting code please use code tags, see here.
D2 is incorrect, the time is 11:10
Date is
=LEFT(A2,FIND(" ",A2)-1)+0
Time is
=RIGHT(A2,FIND(" ",A2)+1)+0
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hello Norie,
Sample file attached for your quick reference.
Thanks in Advance
Hello Special-K,
Thanks for your timely response.I have tried using the same formula however it's not producing the expected output
Try these
C3: =INT(A3)
D3: =A3-C3
Same for E3 and F3, just change the references to B3.
Hello Jonmol,
Tries applying the same formula but not luck it is giving
Please Login or Register to view this content.
Date should be ok, I had to convert your data to UK date in text before running the formula.Originally Posted by pramoth.u
Hello Special-K,
Thanks for your timely response.I have tried using the same formula however it's not producing the expected output
Time formula is wrong it should be
=MID(A3,FIND(" ",A3)+1,8)+0
Hello Special-K,
Thanks for your valuable support in sharing the formula for time conversion however time conversion is not a challenge for me i have done it using below formula.
Formula:
Please Login or Register to view this content.
However my challenge is converting the date to excel readable formula to do some calculation.
Last edited by pramoth.u; 06-06-2017 at 12:32 AM. Reason: formula reference
Hi try this is in c3
Formula:Please Login or Register to view this content.
Punnam
Hello Punnam,
Thanks for sharing the required formula and it's producing the right output
I Also tried the below formula to convert date and time in excel readable format of the data i shared.
Date:Formula:Please Login or Register to view this content.
Time:Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks