Wednesday, April 25, 2012

yogi_For Time Given In hh:mm:ss Show It Supressing Hour Where Specified Time is Less Than 1 Hour

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #516    Apr 25, 2012

user yv6eda said: 
Hello guys/gals. 
A rookie here, please be patient with me. Please help me with this. I have a list of video clips each one with a cell displaying length in time. Format used is HH:MM:SS. Everything works, but I want to hide or remove de HH part if the video is under an hour. 
Current: 00:05:23 
Hope: 5:23 
Sorry is the question is dumb... Thanks in advance... 
following is a discussion on and solution to the problem