Hours:Minutes

[sureshsonti]

I have a table with Employee Code, Punch In and Punch Out values. The Data Type is Date/Time. I am trying to calculate hours:minutes for each employee and then sum all hours:minutes. I used this DAX statement 

TODAY_HOURS = DATEDIFF('tick'[drvt.punch_in_time_1], 'tick'[drvt.punch_out_time_1],HOUR)

It looks wrong. Please help

[v-jiascu-msft]

Hi @sureshsonti,

Could you please tell me if you get the answer or the solution?

Best Regards,

Dale

[sureshsonti]

Dale,

Your solution solved my issue. Thanks for your help.

[v-jiascu-msft · Accepted solution]

Hi @sureshsonti,

Seems these two columns don't have proper data type. Please check and change them into time.

Best Regards,

Dale

[ChrisMendoza]

I believe the DATEDIFF ( ) requires the datetime value not just the time value. Try it with a datetime field.