Forum Discussion
Formula Miscalculation
https://1drv.ms/x/s!Askv3RjJkg9lhkmphKeJesnxPwsg?e=dnUFj5&nav=MTVfe0FFNDQ1OThGLTVBQzAtNDNFNi04MDQ1LUIzRTM2MERFQ0ZEQ30 https://1drv.ms/x/s!Askv3RjJkg9lhksH-PJCTu28QzXM?e=LfhF50&nav=MTVfezY3OTc5MjE3LUN...
CV2023 Well, begin by sharing the template (via Onedrive or similar) so that we can have a look at it. Enter some fake data in it that demonstrates the problem.
Ok I have posted the samples
CV2023 Have a look at the attached file where I completely changed the formula in the Blank sheet. The existing one was a monster. See if the revised template works better.
- Maybe I am doing something wrong or the file is corrupted. I can see the sample but when I try to input(copy&paste) into an active sheet or even the samples I have it says there is a problem with the formula
And better to use formula which Riny_van_Eekelen suggested, here I repeat his file
In formula you calculate COUNT on
TimeSheet3353363738394041434445464748495152535455565759586061624[@[Time In]:[Time Out]]but current table has name
TimeSheet335336373839404143444546474849515253545556575958606162413
If to rename table as, for example, TimeSheet061023 and use that name in formula, it calculates correctly.
- How do I find the name and rename the timesheet/table? I have always just duplicated the sheets so I have never even tried to use the timesheet name excel assigned.
