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:
=COUNTIFS(D3:AH3, ">10:31", D3:AH3, "<=10:45") to understand & get no. of days this person is coming between 10:31 HRS to 10:45 HRS. But Result is showing ZERo.
May be because of Formating of Data. Could you help me with this.
6 Replies
I feel there is some issue with the input data.
Because when I enter the data in this format it works perfectly.
Format: "HH:MM AM"e.g. 10:32 AM
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 / xlsxCell Format: Time (h:mm, h:mm AM/PM)
if still does not work, can u pls attach the file here?
