Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Convert total mins to HH:MM

Hello need help with Dax formula that can take total min and convert dec number.

 

example 498 need to display 8.3

  • Anonymous's avatar
    Anonymous
    6 years ago
    Hi,Anonymous 
     
    Will this work for you?
     
    SUMMINS = SUMX(Sheet1,[Mins]/60)
     
    You can always leave a message if you have more questions.
     
    Best,
    Paul

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    Hi,Anonymous 
     
    Will this work for you?
     
    SUMMINS = SUMX(Sheet1,[Mins]/60)
     
    You can always leave a message if you have more questions.
     
    Best,
    Paul