Auto update of current time & insertion of next day date within one cell

RJTA1IC

New Member
Joined
Sep 6, 2014
Messages
8
:confused:

Salutations,

Should the title be confusing, here is what I am attempting to do.

I have a note cheat sheet that contains 65 different templates that begin with the current time and usually end with the following days date.
i know i can have one field with (i.e cell a1= current time formula, cell a2 would be the notation, cell a3 would be the following date formula), however in this manner when I copy and paste from excel to the any other window there is a very big indentation from the time to the note to the date.

In what manner would i be able to have all this in one cell?

For those who would reply that I can change the time & date manually; yes i can, however: changing time+changing date+copying & pasting= lost time.

To any & all who have thoughts or comments & solutions, I appreciate your time in advance in trying to help.

Thank you.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Would the =NOW() function work for you? This function returns the current date and time.

EDIT:

You could also play with the cell formatting to put it in the order you want.

Go to Format Cells > Number > Custom and put:
h:mm AM/PM m/d/yyyy
If you want it like 9:59 PM 9/6/2014

Or whatever custom formatting you want to make it look like the values you want.
 
Last edited:
Upvote 0
DISCO!!! Thank you so much for your help one & all.
To Alex0013 for the reminder of the formating (conditional & otherwise).
To Peter_SSs for the combo :D.

Thank you!
 
Upvote 0
No problem. Thanks for letting us know.
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,938
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top