Convert duration to whole number

[Vanessa250919]

Hi community,

I need help, I trie to convert a duration number to whole number but in my whole number a need durations in hours 

Exemple : 05:02 = 5 hours 

[v-yiruan-msft]

Hi @Vanessa250919 ,

Please try to create a calculated column with below formula supposed to duration field is Text type:

Hour = VALUE(LEFT('Table'[Duration],FIND(":",'Table'[Duration],1,0)-1))

Best Regards

Rena

[camargos88]

@Vanessa250919 ,

[Greg_Deckler]

See this article that will demonstrate how to convert to seconds and from there you could convert to hours easily. https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

[Vanessa250919]

@Greg_Deckler  I just read this post, but it's not the same problem . I don't have a duration whole number, it's my problem 🙂 

[Greg_Deckler]

OK @Vanessa250919  I'll get this right at some point, here is a duration to seconds converter: https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92

[Greg_Deckler]

Sorry @Vanessa250919 I thought that article referenced this one:

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486