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

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Alex0013

Board Regular
Joined
Jul 23, 2014
Messages
158
Office Version
  1. 365
Platform
  1. Windows
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

RJTA1IC

New Member
Joined
Sep 6, 2014
Messages
8
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

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
59,294
Office Version
  1. 365
Platform
  1. Windows
No problem. Thanks for letting us know.
 
Upvote 0

Forum statistics

Threads
1,190,677
Messages
5,982,213
Members
439,769
Latest member
trungminh2802

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
Top