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 when I copy your data in my sheet and try, it works.
Just check couple of things:
Excel file type is: xls / xlsx
Cell Format: Time (h:mm, h:mm AM/PM)
if still does not work, can u pls attach the file here?
Hii Bhushan, i have attached herewith the file. Please help me out & you can call me up on + 91 8171232221 bhushanz
shashank1234 found the issue.
You have an extra tick - ' before the time, example: '10:32So 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).
