Me again
I want to autominously split a cell that reads ‘3/07/2014 0:00”
Basically i want to extract the time
And dont want to use the text to columns function
Me again
I want to autominously split a cell that reads ‘3/07/2014 0:00”
Basically i want to extract the time
And dont want to use the text to columns function
Last edited by BobbyH; 09-24-2012 at 12:38 AM.
try
=MOD(A1,1) ->format to time
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
i couldnt get it to work mate
try this 1...
=TIME(HOUR(A1),MINUTE(A1),0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
spot on mate thanks heaps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks