Automating date and time in excel help

Microsoft Excel 2013 32/64-bit - license...
May 15, 2017 at 08:41:43
Specs: Windows 10, core I7 7500k 32Gb ddr4 ram
I have a call tracker that I am trying to automate the input of the date and time. My time is not working correctly and my dates are changed for all entries when the tracker is updated then next day.

I uploaded it to my dropbox so you can see exactly whats happening.

https://www.dropbox.com/s/luv4417ch...


See More: Automating date and time in excel help

Reply ↓  Report •


#1
May 15, 2017 at 11:20:09
I can't access the file right now, but I'll toss this out...

If you are using Excel functions such as TODAY() or NOW(), you should be aware that those functions are known as "Volatile Functions"

From: http://www.decisionmodels.com/calcs...

A Volatile Function is one that causes recalculation of the formula in the cell where it resides every time Excel recalculates.

This occurs regardless of whether the precedent data and formulas on which the formula depends have changed, or whether the formula also contains non-volatile functions.

In other words, =TODAY() will return the then-current date, based on the OS date, which means it will change every day. = NOW() will update the Time portion every time the sheet does any type of calculation, anywhere on the sheet.

The only way that I know of to automate the entry of the Date and Time and have it remain static is to use VBA (a macro) which can write the actual date and time in a cell as opposed to having Excel pull it from the OS via a function.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Reply ↓  Report •
Related Solutions


Ask Question