In time and out time on different days

[dsmitha]

Hi,

I request your guidance and help to solve this issue of mine related to a call centre dashboard

employees log in at 07:00 pm on 01st July 2022 and they log out at 03:00 am on 02nd July 2022. How can i calculate the hours worked considering it as a single day ( i.e  8 hours duty )

regards,

dsmitha

[v-stephen-msft · Accepted solution]

Hi @dsmitha ,

Do you want to calculate the time interval between dates?

Try the DATEDIFF function:

DATEDIFF(<Date1>, <Date2>, <Interval>)  

DATEDIFF function (DAX) - DAX | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dsmitha]

hi 

v-stephen-msft,

thanks a lot , this is what i was looking for

regards,

dsmitha

PREVIEW