LinkBack URL
About LinkBacks
Hi how can i return just the date in one cell with the below
12/06/2014 11:46:11
Hi how can i return just the date in one cell with the below
12/06/2014 11:46:11
Use INT and format as date.
For example, if the date/time is in A1.
Formula:
Please Login or Register to view this content.
If posting code please use code tags, see here.
Hi.
No need to change anything if all you want to SEE is the date. Just format it as "dd/mm/yyyy"
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
You can also select the cell(s) with the date and time and click on the Home Tab, choose Short Date under the Number group.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Hi Norie, thanks for that it worked perfectly. Is there a way i can bring back just the time ?
If the time/date is in A1 and you want the time in say D1, select D1 and enter =A1 and format the cell as h:mm:ss
... again, there is no need to do anything with a formula.
Irrespective of how your cell is formatted it contains a number like 41802.49.
You can choose to format it to show either the date (the integer part) as in your original question, or the time (the decimal part) - with a "hh:mm:ss" format.
if you really need to separate it =MOD(A1,1)
or =int(a1) in b1 and =a1-b1 in c1
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks