User Profile
Jeff256
Copper Contributor
Joined Aug 17, 2023
User Widgets
Recent Discussions
Re: Excel will not subtract times with decimal seconds.
You guys have been a great help, but alas... I get the same behavior with "excel /safe" (but I learned something new - didn't know about this). I may have an unusual system date format for the USA, but it's certainly not unreasonable. Here's everything:Re: Excel will not subtract times with decimal seconds.
SergeiBaklan I'm sorry... are you saying it WILL work with the setting unchecked? I ask because I do have this unchecked: And the separators above match those of the OS: I'm not sure what you're stating... Just to confirm, I checked "Use system separators" and this did not work either.How do I define a 'seed' value for a cell in a circular reference?
My spreadsheet containing a circular reference usually works, but sometimes it puts #NUM! in both cells and stays stuck like this. To correct this I enter an appropriate value in the critical cell, to break the circular reference, and a solution is provided. I then Ctrl-Z to get the formula back in the cell and get the actual answer. --> How can I 'seed' the cell with an approximate value so there is no error? Example: In one cell, 'performance' is the inverse of 'temperature'. If 'temperature' becomes zero, 'performance' becomes infinite and the circular reference breaks. If I set 'temperature' to 50, 'performance' becomes 0.02, the circular reference would work, and when I Ctrl-Z to change 'temperature' back to the inverse of 'performance' the circular reference works.
