Forum Discussion

lmatera's avatar
lmatera
Frequent Visitor
10 years ago
Solved

Sum hours

Hello!   I need to sum hours (like in the pic) but I haven´t been able to develop it...   Total: 49:00   Anyone? =)   Thanks!
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    Some variation of this should work for you, this formula converts the text below into minutes and divides by 60 to get hours.

     

    This is a DAX custom column

    =(LEFT([EST Block time],FIND(":",[EST Block time])-1)*60+RIGHT([EST Block time],LEN([EST Block time])-FIND(":",[EST Block time]))*1)/60

     

    If you want it in the format below, you would have to have to do something like:

     

    DAX

     

    Custom Columns

    [Hours]=LEFT([EST Block time],FIND(":",[EST Block time])-1)*1

    [Minutes]=RIGHT([EST Block time],LEN([EST Block time])-FIND(":",[EST Block time]))*1)*1

     

    Custom Field

    Sum:=CONCATENATE(SUM([Hours])+ROUNDDOWN(SUM([Minutes])/60,0),":",MOD(SUM([Minutes]),60))

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Not entirely certain what you are asking but your formula for T2 seems overly complex. If your TM data is always hh:mm:ss then use LEFT([column],2) to get your hours, RIGHT([column],2) to get your seconds and MID([column],4,2) to get your minutes. I think I have that correct.

alekskate's avatar
alekskate
Regular Visitor
8 years ago

I need, sum "TM"

 

For example:

 

Resource       TM

Adam            2:00

Leslie             1:20

Adam            5:42

Leslie             3:39

 

Result:

Adam: 7:42 hours

Lestie: 4:59 hours