LinkBack URL
About LinkBacks
Hi,
I have a excel with lots of datetime, weekly.
Is there a macro to splt the date and time from datetime field?
I have a sheet for example
Hi,
I have a excel with lots of datetime, weekly.
Is there a macro to splt the date and time from datetime field?
I have a sheet for example
Last edited by mdek; 02-08-2016 at 03:36 PM.
you could just say
=a1
in both cells and then change the format
custom format
DD/MM/YYYY
to just show the date
and then
HH:MM:SS
for the time
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Why do you need a macro?
date:Formula:
Please Login or Register to view this content.
time:Formula:Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
The data is dynamic, so with a push of a button, data will be read from a database file and the datetime has te be seperate for the orders
Please Login or Register to view this content.
Try the attached code.
Thanks you all for the input!!
Got i working perfect!!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks