This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

How to convert Duration 00:00:00 into "0 h 00 min"

Posted on 07-19-2020 01:56 PM
Tony_Insua
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

What is the virtual column expression to convert Duration column of 00:00:00 into “0 h 00 min” removing the seconds.
Thanks!

Solved Solved
0 7 912
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Tony_Insua
Bronze 5
Bronze 5
In response to Suvrutt_Gurjar
Reply posted on --/--/---- --:-- AM

Thanks @Suvrutt_Gurjar

The final expression I landed on was this. Always a big help.

IF(
HOUR([DURATION])=0,
CONCATENATE(MINUTE([DURATION]), " min"),

IF(
HOUR([DURATION])>0,
CONCATENATE(HOUR([DURATION]), "h “, MINUTE([DURATION]), " min”), “”)

)

View solution in original post

Jump to Solution
7 REPLIES 7
Top Labels in this Space