Forum Discussion

sureshsonti's avatar
sureshsonti
Icon for Helper II rankHelper II
8 years ago
Solved

Hours:Minutes

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 ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi sureshsonti,

     

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

    Hours_Minutes

     

    Best Regards,

    Dale

     

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi sureshsonti,

 

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

 

Best Regards,

Dale

sureshsonti's avatar
sureshsonti
Icon for Helper II rankHelper II
8 years ago

Dale,

Your solution solved my issue. Thanks for your help.