| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Difference between NOW() and TODAY()
Hi community,
in excel help I found the information TODAY(): "Returns the serial number of the current date. The serial number is the date-time code used by Microsoft Excel for date and time calculations. If the cell format was General before the function was entered, the result is formatted as a date." NOW(): "Returns the serial number of the current date and time. If the cell format was General before the function was entered, the result is formatted as a date. .... The NOW function changes only when the worksheet is calculated or when a macro that contains the function is run. It is not updated continuously. " I have a cell formatted as TT. MMM JJ, hh:mm ;; when I copy-n-paste a cell showing NOW() I get the current time but an older date; when I copy-n-paste a cell showing today() I get the current date but the time 00:00. I want to have after copy-n-pasting the current date and the current time. Do I have to force a re-calculation (F9) or calculate in VBA? Michael |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Difference between NOW() and TODAY()
NOW() should give you what you require. Can you give an example of what you
get? -- Kind regards, Niek Otten Microsoft MVP - Excel "Michael.Tarnowski" wrote in message ... Hi community, in excel help I found the information TODAY(): "Returns the serial number of the current date. The serial number is the date-time code used by Microsoft Excel for date and time calculations. If the cell format was General before the function was entered, the result is formatted as a date." NOW(): "Returns the serial number of the current date and time. If the cell format was General before the function was entered, the result is formatted as a date. ... The NOW function changes only when the worksheet is calculated or when a macro that contains the function is run. It is not updated continuously. " I have a cell formatted as TT. MMM JJ, hh:mm ;; when I copy-n-paste a cell showing NOW() I get the current time but an older date; when I copy-n-paste a cell showing today() I get the current date but the time 00:00. I want to have after copy-n-pasting the current date and the current time. Do I have to force a re-calculation (F9) or calculate in VBA? Michael |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Difference between NOW() and TODAY()
What is showing up in the formula bar when you copy-n-paste the cell
showing NOW()? Are the cell(s) you're copying from in the same workbook as the cell(s) you're copying to? Are the workbooks set to the same date format (Tools/Options/Calculation)? In article , "Michael.Tarnowski" wrote: Hi community, in excel help I found the information TODAY(): "Returns the serial number of the current date. The serial number is the date-time code used by Microsoft Excel for date and time calculations. If the cell format was General before the function was entered, the result is formatted as a date." NOW(): "Returns the serial number of the current date and time. If the cell format was General before the function was entered, the result is formatted as a date. ... The NOW function changes only when the worksheet is calculated or when a macro that contains the function is run. It is not updated continuously. " I have a cell formatted as TT. MMM JJ, hh:mm ;; when I copy-n-paste a cell showing NOW() I get the current time but an older date; when I copy-n-paste a cell showing today() I get the current date but the time 00:00. I want to have after copy-n-pasting the current date and the current time. Do I have to force a re-calculation (F9) or calculate in VBA? Michael |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Difference between NOW() and TODAY()
To clarify my posting: I want to use a time stamping mechanism by
using a circular definition =IF(D10=0;NOW();D10) the point is: when should I use NOW() and when TODAY() to get a timestamp like 10.Feb.2009 15:45 (actual dates and times)? Michael Michael.Tarnowski wrote: Hi community, in excel help I found the information TODAY(): "Returns the serial number of the current date. The serial number is the date-time code used by Microsoft Excel for date and time calculations. If the cell format was General before the function was entered, the result is formatted as a date." NOW(): "Returns the serial number of the current date and time. If the cell format was General before the function was entered, the result is formatted as a date. ... The NOW function changes only when the worksheet is calculated or when a macro that contains the function is run. It is not updated continuously. " I have a cell formatted as TT. MMM JJ, hh:mm ;; when I copy-n-paste a cell showing NOW() I get the current time but an older date; when I copy-n-paste a cell showing today() I get the current date but the time 00:00. I want to have after copy-n-pasting the current date and the current time. Do I have to force a re-calculation (F9) or calculate in VBA? Michael |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Difference between NOW() and TODAY()
On Feb 10, 5:22 pm, JE McGimpsey wrote:
What is showing up in the formula bar when you copy-n-paste the cell showing NOW()? Are the cell(s) you're copying from in the same workbook as the cell(s) you're copying to? Are the workbooks set to the same date format (Tools/Options/Calculation)? In article , "Michael.Tarnowski" wrote: Hi community, in excel help I found the information TODAY(): "Returns the serial number of the current date. The serial number is the date-time code used by Microsoft Excel for date and time calculations. If the cell format was General before the function was entered, the result is formatted as a date." NOW(): "Returns the serial number of the current date and time. If the cell format was General before the function was entered, the result is formatted as a date. ... The NOW function changes only when the worksheet is calculated or when a macro that contains the function is run. It is not updated continuously. " I have a cell formatted as TT. MMM JJ, hh:mm ;; when I copy-n-paste a cell showing NOW() I get the current time but an older date; when I copy-n-paste a cell showing today() I get the current date but the time 00:00. I want to have after copy-n-pasting the current date and the current time. Do I have to force a re-calculation (F9) or calculate in VBA? Michael I want to realize a timestamping mechanism by using circular references. In sheet A I have a cell with =IF(D10=0;NOW();D10); when copy-n-pasting this row to sheet B an older (the last update of sheetA! D10) is showed in sheet B; but I want the time of copy-n-pasting. Michael |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Difference between NOW() and TODAY()
On Feb 10, 5:42 pm, "Michael.Tarnowski" wrote:
On Feb 10, 5:22 pm, JE McGimpsey wrote: What is showing up in the formula bar when you copy-n-paste the cell showing NOW()? Are the cell(s) you're copying from in the same workbook as the cell(s) you're copying to? Are the workbooks set to the same date format (Tools/Options/Calculation)? In article , "Michael.Tarnowski" wrote: Hi community, in excel help I found the information TODAY(): "Returns the serial number of the current date. The serial number is the date-time code used by Microsoft Excel for date and time calculations. If the cell format was General before the function was entered, the result is formatted as a date." NOW(): "Returns the serial number of the current date and time. If the cell format was General before the function was entered, the result is formatted as a date. ... The NOW function changes only when the worksheet is calculated or when a macro that contains the function is run. It is not updated continuously. " I have a cell formatted as TT. MMM JJ, hh:mm ;; when I copy-n-paste a cell showing NOW() I get the current time but an older date; when I copy-n-paste a cell showing today() I get the current date but the time 00:00. I want to have after copy-n-pasting the current date and the current time. Do I have to force a re-calculation (F9) or calculate in VBA? Michael I want to realize a timestamping mechanism by using circular references. In sheet A I have a cell with =IF(D10=0;NOW();D10); when copy-n-pasting this row to sheet B an older (the last update of sheetA! D10) is showed in sheet B; but I want the time of copy-n-pasting. Michael I realized that putting the cursor in the formula bar and hitting <Return before copy-n-pating updates the cell I want to copy, thus I get the current time in sheet B when I paste. How can I force the update of sheet A before copy-n-paste to sheet B? Michael |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Difference between NOW() and TODAY()
You would need NOW().
TODAY() gives zero time on the current day. -- David Biddulph "Michael.Tarnowski" wrote in message ... To clarify my posting: I want to use a time stamping mechanism by using a circular definition =IF(D10=0;NOW();D10) the point is: when should I use NOW() and when TODAY() to get a timestamp like 10.Feb.2009 15:45 (actual dates and times)? Michael Michael.Tarnowski wrote: Hi community, in excel help I found the information TODAY(): "Returns the serial number of the current date. The serial number is the date-time code used by Microsoft Excel for date and time calculations. If the cell format was General before the function was entered, the result is formatted as a date." NOW(): "Returns the serial number of the current date and time. If the cell format was General before the function was entered, the result is formatted as a date. ... The NOW function changes only when the worksheet is calculated or when a macro that contains the function is run. It is not updated continuously. " I have a cell formatted as TT. MMM JJ, hh:mm ;; when I copy-n-paste a cell showing NOW() I get the current time but an older date; when I copy-n-paste a cell showing today() I get the current date but the time 00:00. I want to have after copy-n-pasting the current date and the current time. Do I have to force a re-calculation (F9) or calculate in VBA? Michael |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Difference between NOW() and TODAY()
On Feb 10, 6:29 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote: You would need NOW(). TODAY() gives zero time on the current day. -- David Biddulph "Michael.Tarnowski" wrote in message ... To clarify my posting: I want to use a time stamping mechanism by using a circular definition =IF(D10=0;NOW();D10) the point is: when should I use NOW() and when TODAY() to get a timestamp like 10.Feb.2009 15:45 (actual dates and times)? Michael Michael.Tarnowski wrote: Hi community, in excel help I found the information TODAY(): "Returns the serial number of the current date. The serial number is the date-time code used by Microsoft Excel for date and time calculations. If the cell format was General before the function was entered, the result is formatted as a date." NOW(): "Returns the serial number of the current date and time. If the cell format was General before the function was entered, the result is formatted as a date. ... The NOW function changes only when the worksheet is calculated or when a macro that contains the function is run. It is not updated continuously. " I have a cell formatted as TT. MMM JJ, hh:mm ;; when I copy-n-paste a cell showing NOW() I get the current time but an older date; when I copy-n-paste a cell showing today() I get the current date but the time 00:00. I want to have after copy-n-pasting the current date and the current time. Do I have to force a re-calculation (F9) or calculate in VBA? Michael Thanks David, you affirmed my experiments Michael |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Difference between NOW() and TODAY()
On Feb 10, 6:29 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote: You would need NOW(). TODAY() gives zero time on the current day. -- David Biddulph "Michael.Tarnowski" wrote in message ... To clarify my posting: I want to use a time stamping mechanism by using a circular definition =IF(D10=0;NOW();D10) the point is: when should I use NOW() and when TODAY() to get a timestamp like 10.Feb.2009 15:45 (actual dates and times)? Michael Michael.Tarnowski wrote: Hi community, in excel help I found the information TODAY(): "Returns the serial number of the current date. The serial number is the date-time code used by Microsoft Excel for date and time calculations. If the cell format was General before the function was entered, the result is formatted as a date." NOW(): "Returns the serial number of the current date and time. If the cell format was General before the function was entered, the result is formatted as a date. ... The NOW function changes only when the worksheet is calculated or when a macro that contains the function is run. It is not updated continuously. " I have a cell formatted as TT. MMM JJ, hh:mm ;; when I copy-n-paste a cell showing NOW() I get the current time but an older date; when I copy-n-paste a cell showing today() I get the current date but the time 00:00. I want to have after copy-n-pasting the current date and the current time. Do I have to force a re-calculation (F9) or calculate in VBA? Michael Thanks David, you affirmed my experiments Michael |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Difference between NOW() and TODAY()
On Feb 10, 6:29 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote: You would need NOW(). TODAY() gives zero time on the current day. -- David Biddulph "Michael.Tarnowski" wrote in message ... To clarify my posting: I want to use a time stamping mechanism by using a circular definition =IF(D10=0;NOW();D10) the point is: when should I use NOW() and when TODAY() to get a timestamp like 10.Feb.2009 15:45 (actual dates and times)? Michael Michael.Tarnowski wrote: Hi community, in excel help I found the information TODAY(): "Returns the serial number of the current date. The serial number is the date-time code used by Microsoft Excel for date and time calculations. If the cell format was General before the function was entered, the result is formatted as a date." NOW(): "Returns the serial number of the current date and time. If the cell format was General before the function was entered, the result is formatted as a date. ... The NOW function changes only when the worksheet is calculated or when a macro that contains the function is run. It is not updated continuously. " I have a cell formatted as TT. MMM JJ, hh:mm ;; when I copy-n-paste a cell showing NOW() I get the current time but an older date; when I copy-n-paste a cell showing today() I get the current date but the time 00:00. I want to have after copy-n-pasting the current date and the current time. Do I have to force a re-calculation (F9) or calculate in VBA? Michael Thanks David, you affirmed my experiments Michael |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
| IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
| Today()-1 | Excel Discussion (Misc queries) | |||
| charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
|
=IF(OR(TODAY() |
Excel Discussion (Misc queries) | |||
Linear Mode
