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...
Input Data has been extracted from Biometric Machine. You can check this as an example.
| 21-May-2019 | 22-May-2019 | 23-May-2019 | 24-May-2019 | 25-May-2019 | 26-May-2019 | 27-May-2019 | 28-May-2019 | 29-May-2019 | 30-May-2019 | 31-May-2019 |
| Weekly Off | Absent | 10:38 | 10:25 | 10:35 | 10:28 | 10:41 | Weekly Off | 10:31 | 10:45 | 10:30 |
| 21:05 | 21:25 | 21:06 | 21:10 | 21:07 | 21:03 | 21:06 | 21:08 |
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?