AnsweredAssumed Answered

Hours and minutes... Calculation scenarios

Question asked by AndrewJudd on Jul 18, 2015
Latest reply on Jul 18, 2015 by philmodjunk

Title

Hours and minutes... Calculation scenarios

Post

Hi all, I have a calculation below that is part of a calculation field description of an artwork. if the artwork is a video the user enters the duration in hours, minutes and seconds. Obviously sometimes a video might be over an hour, might just be minutes and seconds, or might just be seconds. I have got as far as the below. Which is pretty close.

However, when the hours is "1" the calculation is not returning a result. Over two hours is fine. Should make sense below.. 

Any ideas? thank you

 

If (Hours >1 ; Hours & " Hours" &  " : " &  (If (Hours = "1" ; Hours & " Hour" ) & If (not IsEmpty (Minutes) ; Minutes & " Minutes" & " : ") & Seconds & " Seconds") ;

 

 

Outcomes