Sep 02 2021 11:33 AM
I hit shortcut keys for applying static time with only one cell selected. I expected it would be applied to this cell only, but instead it got applied to all of my cells containing time values. I tried clearing all formating from these cells, changing time format, but nothing works. On top of that it made my subtraction formulas which were tied to those data dysfunctional ; meaning I can see these formulas displayed in cells, but hitting enter won't return the result. Also, all the formated cells display time in decimals.
Is there any fix for this or is static time supposed to be irreversible?
Sep 02 2021 12:23 PM
Could you please share sample file?