I tried opening the file and got also an error message. Tried to download the file, but it changed in a txt file, and nothing appears. So there ...
Nice one Clark! Not sure if it will work with all the times, but it's working fine for this one.
Sunny, both files opened here perfectly in Excel 2013. Frans
In respons to your second question. It's a combination of underneath functions and settings. You have to set your cell as number, whole number w...
Good advice Phil. But sometimes it's difficult finding something where you don't know the name or words that give the solution. Mitul: I'm not sure...
Hi Mitul, I'm afraid I don't understand what you want. A certain calculation of minutes between two times indicates that you must have two cells, d...
Please check your post after posting. There is no attachment!
AH, you made a new thread following my advice? Sorry to see no reactions at this moment. Good luck! Frans
Hi Mitul, The problem is your data is not consistent. When you make a table every column has it's own kind or value and every row got the proper...
Interesting questions Franz! You dig in some terrain I don't know much about. Hope other people here on the Forum can have a look. Your Topic Title wa...
Maybe a moderator can remove this whole item?
Hi Ryan, welcome to the Forum here! I suppose that 3% less as well as 3% more than the value in D30 counts? And exact 3% also? See attached f...
Find and replace: find '$EEI$72' and replace it with '$CZ$72' Frans
Hi Ishan Sahni, welcome here on Mynda's Forum. Not sure what you mean by 'Freeze'? Did you use the option on the Ribbon: tab 'view', item 'Freeze P...
As far as I can see it's maybe best to round also the complete formula in column G to 2 decimals. Now G6 is giving $ 24,65404 etc. and it calculate...