| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I automatically enter the current date or current time into a
Hello everyone and thanks again to the kind people who, for some reason, take
the time to help me through this website. As indicated in my subject line, it seems to me that there should be an easy way to do this. Thank you- Ben |
|
#2
|
|||
|
|||
|
Hi Ben
Your subject line was truncated. I am assuming you wanted date? =today() will give you the current date. HTH "Ben" wrote: Hello everyone and thanks again to the kind people who, for some reason, take the time to help me through this website. As indicated in my subject line, it seems to me that there should be an easy way to do this. Thank you- Ben |
|
#3
|
|||
|
|||
|
Thank you Ray!
How about entering the current time into a cell? Ben "Ray A" wrote: Hi Ben Your subject line was truncated. I am assuming you wanted date? =today() will give you the current date. HTH "Ben" wrote: Hello everyone and thanks again to the kind people who, for some reason, take the time to help me through this website. As indicated in my subject line, it seems to me that there should be an easy way to do this. Thank you- Ben |
|
#4
|
|||
|
|||
|
=NOW()
-- Gary''s Student "Ben" wrote: Thank you Ray! How about entering the current time into a cell? Ben "Ray A" wrote: Hi Ben Your subject line was truncated. I am assuming you wanted date? =today() will give you the current date. HTH "Ben" wrote: Hello everyone and thanks again to the kind people who, for some reason, take the time to help me through this website. As indicated in my subject line, it seems to me that there should be an easy way to do this. Thank you- Ben |
|
#5
|
|||
|
|||
|
Ben,
You subject line was truncated, which is a reminder of why you should always ask your question in the body of the message, not the subject. You can enter the current date in a cell with =TODAY(). You can enter the current date and time in a cell with =NOW() Both of these formulas will update everytime the worksheet is calculated. If you want to insert a static date, on that will not change, press CTRL+<semi-colon Use CTRL+SHIFT+<colon for the time. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Ben" wrote in message ... Hello everyone and thanks again to the kind people who, for some reason, take the time to help me through this website. As indicated in my subject line, it seems to me that there should be an easy way to do this. Thank you- Ben |
|
#6
|
|||
|
|||
|
Note that NOW() returns both the Date and Time. If you just want the
time, use MOD(NOW(),1). In article , Gary''s Student wrote: =NOW() -- Gary''s Student "Ben" wrote: Thank you Ray! How about entering the current time into a cell? |
|
#7
|
|||
|
|||
|
can I add and subtract time values?
Hello!
Thanks again everyone for all of the help. I am essentially trying to make a timesheet. Is it possible to add or subtract time values? For example, if I have a starting and ending time entered, is it possible to calculate the time between? Thank you. Ben "Chip Pearson" wrote: Ben, You subject line was truncated, which is a reminder of why you should always ask your question in the body of the message, not the subject. You can enter the current date in a cell with =TODAY(). You can enter the current date and time in a cell with =NOW() Both of these formulas will update everytime the worksheet is calculated. If you want to insert a static date, on that will not change, press CTRL+<semi-colon Use CTRL+SHIFT+<colon for the time. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Ben" wrote in message ... Hello everyone and thanks again to the kind people who, for some reason, take the time to help me through this website. As indicated in my subject line, it seems to me that there should be an easy way to do this. Thank you- Ben |
|
#8
|
|||
|
|||
|
can I add and subtract time values?
Just subtract the two cells.
Be aware that if the result is negative and you have tools|options|calculation tab|1904 date system unchecked, then you'll see: ######. If you check this option, then you'll be able to see negative times--but this can be a problem. If you have dates in that file, they'll have changed by 4 years and one day. And copying dates between different files (with that option different in both) is a problem, too. Ben wrote: Hello! Thanks again everyone for all of the help. I am essentially trying to make a timesheet. Is it possible to add or subtract time values? For example, if I have a starting and ending time entered, is it possible to calculate the time between? Thank you. Ben "Chip Pearson" wrote: Ben, You subject line was truncated, which is a reminder of why you should always ask your question in the body of the message, not the subject. You can enter the current date in a cell with =TODAY(). You can enter the current date and time in a cell with =NOW() Both of these formulas will update everytime the worksheet is calculated. If you want to insert a static date, on that will not change, press CTRL+<semi-colon Use CTRL+SHIFT+<colon for the time. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Ben" wrote in message ... Hello everyone and thanks again to the kind people who, for some reason, take the time to help me through this website. As indicated in my subject line, it seems to me that there should be an easy way to do this. Thank you- Ben -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set tab or enter keys to automatically move to different cells | Excel Discussion (Misc queries) | |||
| set checkbox to enter date when checked and NOT recalculate | Excel Worksheet Functions | |||
| Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
Linear Mode
