I use date/time forumulas in spreadsheets and these did not compute the
date/time after the time change Sunday. When I opened the forumula and hit
"enter", the correct time showed up. What is causing this and how to fix it?

Tools Options Calculation Automatic
--
Gary''s Student - gsnu200837

place this in a empty cell to check if your calculation is Automatic

=INFO("recalc")

if not, go to Tool Options Calculation
check on Automatic

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"Mark" wrote:

I use date/time forumulas in spreadsheets and these did not compute the
date/time after the time change Sunday. When I opened the forumula and hit
"enter", the correct time showed up. What is causing this and how to fix it?

I appreciate the suggestions to make the sheet auto recalc, but this is not
the solution. It is in auto recalc mode. Even doing a manual recalc mode
will not do the trick.

Here's the formula: =F3+TIMEVALUE("05:00 PM") where F3 is a day entered by
the user. On Sunday morning, after the time change, this formula returned an
error, causing other formulas depending on it to return "time is invalid".
But when I copied the cell and pasted it's value in another cell, it was
correct.