Hi,
I was wondering if someone know how to convert number to data time format:
eg. I have number 20121231230000 and I need its conversion to 31/12/2012 23:00.
I have tried to use fucntion date with left, mid, right but still I do not know how to extract time.
Thank you
With your number in cell A1:
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
hi there. maybe:
=TEXT(LEFT(A1,8),"00-00-00")+TEXT(RIGHT(A1,6),"00\:00\:00")
format to your desired format
dd/mm/yyyy hh:mm
Edit:
or just
=--TEXT(A1,"00-00-00 00\:00\:00")
Last edited by benishiryo; 12-09-2013 at 05:19 AM.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks