Forum Discussion
Formula not working properly...
I am working on staff attendance management with excel. I am using Biometric to get Punch in data & Punch out data. And this Biometric converts all data into excel. Now i am applying this formula...
shashank1234 found the issue.
You have an extra tick - ' before the time, example: '10:32
So just remove ticks '
Refer attached file, I have cleared Row #3 and correct value is in #AJ3. Please check.
bhushanz , just in case - that's not enough. In other rows are also texts, even without ', which shall be converted to numbers (aka time).