Forum Discussion
shashank1234
Jun 03, 2019Copper Contributor
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...
bhushanz
Jun 03, 2019Copper Contributor
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?
shashank1234
Jun 03, 2019Copper Contributor
Hii Bhushan, i have attached herewith the file. Please help me out & you can call me up on + 91 8171232221 bhushanz