How to calculate average entry time?

[Sean500]

Hi

I am trying to fine the average time in Power BI. I have a table called "Sheet1" which has Date (dd/mm/yyyy), Time (Hr:MM:SS am/pm), EmployeeID, EntryType (Binary 0 AND 1). This is Employee attedance record. Ths table has multiple employees and each employee enters and exit office multiple times on a single day.

I wanted to calculate Average Entry time for each employee. I did in Excel and took the below example for three days for one employee

I tried to do this in below dax measures, but no success. It gives minimum time not average

Average Entry Time = 
VAR MinEntryTime =
    CALCULATE(
        MIN('Sheet1'[Time]),
        'Sheet1'[EntryType] = 1
    )
RETURN
    AVERAGEX(
        VALUES('Sheet1'[EmployeeID]),
        MinEntryTime
    )

Can anyone advise how to do this? I have multiple dates and employee ID's