Hello everyone
I work in a theater, and we use Onlyoffice via our IT supplier.
I’ve created a spreadsheet for our technicians to indicate their working hours:
The problem is this:
the total hours for the period (cells in column F) are calculated correctly, but sometimes, when I reopen the file, the Total cell shows #value!
I then have to edit any cell in the calculation, press Enter and my total is recalculated correctly.
You can see a video of the problem here:
https://www.swisstransfer.com/d/f5b8e80a-b4e7-4adc-9045-ac1ab4d99641
Where does this #value! error come from?
Thanks in advance for your help