What's the quickest way to copy the current date and time to clipboard?
I want to paste the current date and time to a spreadsheet and I am using the NOW() function and copy from there and paste as string but there might be a faster way. There might be an excel solution but a windows solution would be nice too becaue the problem/need isn't really excel specific.
windows microsoft-excel clipboard time date-time
asked Feb 23 at 12:53
Uğur GümüşhanUğur Gümüşhan
88311128
add a comment |
I want to paste the current date and time to a spreadsheet and I am using the NOW() function and copy from there and paste as string but there might be a faster way. There might be an excel solution but a windows solution would be nice too becaue the problem/need isn't really excel specific.
windows microsoft-excel clipboard time date-time
asked Feb 23 at 12:53
Uğur GümüşhanUğur Gümüşhan
88311128
add a comment |
I want to paste the current date and time to a spreadsheet and I am using the NOW() function and copy from there and paste as string but there might be a faster way. There might be an excel solution but a windows solution would be nice too becaue the problem/need isn't really excel specific.
windows microsoft-excel clipboard time date-time
asked Feb 23 at 12:53
Uğur GümüşhanUğur Gümüşhan
88311128
I want to paste the current date and time to a spreadsheet and I am using the NOW() function and copy from there and paste as string but there might be a faster way. There might be an excel solution but a windows solution would be nice too becaue the problem/need isn't really excel specific.
windows microsoft-excel clipboard time date-time
windows microsoft-excel clipboard time date-time
asked Feb 23 at 12:53
Uğur GümüşhanUğur Gümüşhan
88311128
asked Feb 23 at 12:53
Uğur GümüşhanUğur Gümüşhan
88311128
asked Feb 23 at 12:53
Uğur GümüşhanUğur Gümüşhan
88311128
asked Feb 23 at 12:53
Uğur GümüşhanUğur Gümüşhan
88311128
asked Feb 23 at 12:53
Uğur GümüşhanUğur Gümüşhan
88311128
88311128
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
Using Excel, you can use following keyboard shortcuts
ctrl+; enters the current date
ctrl+: enters the current time
Edit cudo's to @phuclv for the missing requirement
Using plain windows, you could use
Win+Rcmd /c time /t | clip
Win+Rcmd /c time /t | clip
answered Feb 23 at 15:30
Lieven KeersmaekersLieven Keersmaekers
883616
But that doesn't copy the date to clipboard
– phuclv
Feb 23 at 15:48
Also that doesn't work on my keyboard layout
– Uğur Gümüşhan
Feb 23 at 15:56
Ive found a shortcut for my layout, it's ctrl+shift+; and ctrl+shitft+: (turkish-Q)
– Uğur Gümüşhan
Feb 23 at 15:58
@phuclv - Enter the value and follow up with Ctr-C
– Lieven Keersmaekers
Feb 24 at 11:25
add a comment |
Step 1: Open Notepad
Step 2: Hit F5
Step 3: Ctrl+A (to select all) then Ctrl+C (to copy)
answered Feb 25 at 8:06
Thirumalai ParthasarathyThirumalai Parthasarathy
312
That's nice. I had no idea.
– Lieven Keersmaekers
Feb 25 at 9:47
add a comment |
To answer the question, it depends which part(s) you want.
If it is just to copy to the clipboard, an executed VBS file would do it.
If it is to put the value into an Excel worksheet, an all VBA solution would suffice. When doing that, I would add the value and then set the numeric format. If you actually wanted a string, it could be:
[A1] = Format(date+time, "mm/dd/yyyy hh:mm AM/PM")
answered Feb 23 at 15:32
Kenneth HobsonKenneth Hobson
111
Excel already has that feature. Don't create a VBA solution just for entering the date or time. See Insert the current date and time in a cell superuser.com/a/1358759/241386
– phuclv
Feb 24 at 12:46
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1408756%2fwhats-the-quickest-way-to-copy-the-current-date-and-time-to-clipboard%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
Using Excel, you can use following keyboard shortcuts
ctrl+; enters the current date
ctrl+: enters the current time
Edit cudo's to @phuclv for the missing requirement
Using plain windows, you could use
Win+Rcmd /c time /t | clip
Win+Rcmd /c time /t | clip
answered Feb 23 at 15:30
Lieven KeersmaekersLieven Keersmaekers
883616
But that doesn't copy the date to clipboard
– phuclv
Feb 23 at 15:48
Also that doesn't work on my keyboard layout
– Uğur Gümüşhan
Feb 23 at 15:56
Ive found a shortcut for my layout, it's ctrl+shift+; and ctrl+shitft+: (turkish-Q)
– Uğur Gümüşhan
Feb 23 at 15:58
@phuclv - Enter the value and follow up with Ctr-C
– Lieven Keersmaekers
Feb 24 at 11:25
add a comment |
Using Excel, you can use following keyboard shortcuts
ctrl+; enters the current date
ctrl+: enters the current time
Edit cudo's to @phuclv for the missing requirement
Using plain windows, you could use
Win+Rcmd /c time /t | clip
Win+Rcmd /c time /t | clip
answered Feb 23 at 15:30
Lieven KeersmaekersLieven Keersmaekers
883616
But that doesn't copy the date to clipboard
– phuclv
Feb 23 at 15:48
Also that doesn't work on my keyboard layout
– Uğur Gümüşhan
Feb 23 at 15:56
Ive found a shortcut for my layout, it's ctrl+shift+; and ctrl+shitft+: (turkish-Q)
– Uğur Gümüşhan
Feb 23 at 15:58
@phuclv - Enter the value and follow up with Ctr-C
– Lieven Keersmaekers
Feb 24 at 11:25
add a comment |
Using Excel, you can use following keyboard shortcuts
ctrl+; enters the current date
ctrl+: enters the current time
Edit cudo's to @phuclv for the missing requirement
Using plain windows, you could use
Win+Rcmd /c time /t | clip
Win+Rcmd /c time /t | clip
answered Feb 23 at 15:30
Lieven KeersmaekersLieven Keersmaekers
883616
Using Excel, you can use following keyboard shortcuts
ctrl+; enters the current date
ctrl+: enters the current time
Edit cudo's to @phuclv for the missing requirement
Using plain windows, you could use
Win+Rcmd /c time /t | clip
Win+Rcmd /c time /t | clip
answered Feb 23 at 15:30
Lieven KeersmaekersLieven Keersmaekers
883616
edited Feb 25 at 7:25
answered Feb 23 at 15:30
Lieven KeersmaekersLieven Keersmaekers
883616
answered Feb 23 at 15:30
Lieven KeersmaekersLieven Keersmaekers
883616
answered Feb 23 at 15:30
Lieven KeersmaekersLieven Keersmaekers
883616
883616
But that doesn't copy the date to clipboard
– phuclv
Feb 23 at 15:48
Also that doesn't work on my keyboard layout
– Uğur Gümüşhan
Feb 23 at 15:56
Ive found a shortcut for my layout, it's ctrl+shift+; and ctrl+shitft+: (turkish-Q)
– Uğur Gümüşhan
Feb 23 at 15:58
@phuclv - Enter the value and follow up with Ctr-C
– Lieven Keersmaekers
Feb 24 at 11:25
add a comment |
But that doesn't copy the date to clipboard
– phuclv
Feb 23 at 15:48
Also that doesn't work on my keyboard layout
– Uğur Gümüşhan
Feb 23 at 15:56
Ive found a shortcut for my layout, it's ctrl+shift+; and ctrl+shitft+: (turkish-Q)
– Uğur Gümüşhan
Feb 23 at 15:58
@phuclv - Enter the value and follow up with Ctr-C
– Lieven Keersmaekers
Feb 24 at 11:25
But that doesn't copy the date to clipboard
– phuclv
Feb 23 at 15:48
But that doesn't copy the date to clipboard
– phuclv
Feb 23 at 15:48
Also that doesn't work on my keyboard layout
– Uğur Gümüşhan
Feb 23 at 15:56
Also that doesn't work on my keyboard layout
– Uğur Gümüşhan
Feb 23 at 15:56
Ive found a shortcut for my layout, it's ctrl+shift+; and ctrl+shitft+: (turkish-Q)
– Uğur Gümüşhan
Feb 23 at 15:58
Ive found a shortcut for my layout, it's ctrl+shift+; and ctrl+shitft+: (turkish-Q)
– Uğur Gümüşhan
Feb 23 at 15:58
@phuclv - Enter the value and follow up with Ctr-C
– Lieven Keersmaekers
Feb 24 at 11:25
@phuclv - Enter the value and follow up with Ctr-C
– Lieven Keersmaekers
Feb 24 at 11:25
add a comment |
Step 1: Open Notepad
Step 2: Hit F5
Step 3: Ctrl+A (to select all) then Ctrl+C (to copy)
answered Feb 25 at 8:06
Thirumalai ParthasarathyThirumalai Parthasarathy
312
That's nice. I had no idea.
– Lieven Keersmaekers
Feb 25 at 9:47
add a comment |
Step 1: Open Notepad
Step 2: Hit F5
Step 3: Ctrl+A (to select all) then Ctrl+C (to copy)
answered Feb 25 at 8:06
Thirumalai ParthasarathyThirumalai Parthasarathy
312
That's nice. I had no idea.
– Lieven Keersmaekers
Feb 25 at 9:47
add a comment |
Step 1: Open Notepad
Step 2: Hit F5
Step 3: Ctrl+A (to select all) then Ctrl+C (to copy)
answered Feb 25 at 8:06
Thirumalai ParthasarathyThirumalai Parthasarathy
312
Step 1: Open Notepad
Step 2: Hit F5
Step 3: Ctrl+A (to select all) then Ctrl+C (to copy)
answered Feb 25 at 8:06
Thirumalai ParthasarathyThirumalai Parthasarathy
312
answered Feb 25 at 8:06
Thirumalai ParthasarathyThirumalai Parthasarathy
312
answered Feb 25 at 8:06
Thirumalai ParthasarathyThirumalai Parthasarathy
312
answered Feb 25 at 8:06
Thirumalai ParthasarathyThirumalai Parthasarathy
312
312
That's nice. I had no idea.
– Lieven Keersmaekers
Feb 25 at 9:47
add a comment |
That's nice. I had no idea.
– Lieven Keersmaekers
Feb 25 at 9:47
That's nice. I had no idea.
– Lieven Keersmaekers
Feb 25 at 9:47
That's nice. I had no idea.
– Lieven Keersmaekers
Feb 25 at 9:47
add a comment |
To answer the question, it depends which part(s) you want.
If it is just to copy to the clipboard, an executed VBS file would do it.
If it is to put the value into an Excel worksheet, an all VBA solution would suffice. When doing that, I would add the value and then set the numeric format. If you actually wanted a string, it could be:
[A1] = Format(date+time, "mm/dd/yyyy hh:mm AM/PM")
answered Feb 23 at 15:32
Kenneth HobsonKenneth Hobson
111
Excel already has that feature. Don't create a VBA solution just for entering the date or time. See Insert the current date and time in a cell superuser.com/a/1358759/241386
– phuclv
Feb 24 at 12:46
add a comment |
To answer the question, it depends which part(s) you want.
If it is just to copy to the clipboard, an executed VBS file would do it.
If it is to put the value into an Excel worksheet, an all VBA solution would suffice. When doing that, I would add the value and then set the numeric format. If you actually wanted a string, it could be:
[A1] = Format(date+time, "mm/dd/yyyy hh:mm AM/PM")
answered Feb 23 at 15:32
Kenneth HobsonKenneth Hobson
111
Excel already has that feature. Don't create a VBA solution just for entering the date or time. See Insert the current date and time in a cell superuser.com/a/1358759/241386
– phuclv
Feb 24 at 12:46
add a comment |
To answer the question, it depends which part(s) you want.
If it is just to copy to the clipboard, an executed VBS file would do it.
If it is to put the value into an Excel worksheet, an all VBA solution would suffice. When doing that, I would add the value and then set the numeric format. If you actually wanted a string, it could be:
[A1] = Format(date+time, "mm/dd/yyyy hh:mm AM/PM")
answered Feb 23 at 15:32
Kenneth HobsonKenneth Hobson
111
To answer the question, it depends which part(s) you want.
If it is just to copy to the clipboard, an executed VBS file would do it.
If it is to put the value into an Excel worksheet, an all VBA solution would suffice. When doing that, I would add the value and then set the numeric format. If you actually wanted a string, it could be:
[A1] = Format(date+time, "mm/dd/yyyy hh:mm AM/PM")
answered Feb 23 at 15:32
Kenneth HobsonKenneth Hobson
111
answered Feb 23 at 15:32
Kenneth HobsonKenneth Hobson
111
answered Feb 23 at 15:32
Kenneth HobsonKenneth Hobson
111
answered Feb 23 at 15:32
Kenneth HobsonKenneth Hobson
111
111
Excel already has that feature. Don't create a VBA solution just for entering the date or time. See Insert the current date and time in a cell superuser.com/a/1358759/241386
– phuclv
Feb 24 at 12:46
add a comment |
Excel already has that feature. Don't create a VBA solution just for entering the date or time. See Insert the current date and time in a cell superuser.com/a/1358759/241386
– phuclv
Feb 24 at 12:46
Excel already has that feature. Don't create a VBA solution just for entering the date or time. See Insert the current date and time in a cell superuser.com/a/1358759/241386
– phuclv
Feb 24 at 12:46
Excel already has that feature. Don't create a VBA solution just for entering the date or time. See Insert the current date and time in a cell superuser.com/a/1358759/241386
– phuclv
Feb 24 at 12:46
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1408756%2fwhats-the-quickest-way-to-copy-the-current-date-and-time-to-clipboard%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
