Sep 28, 2011 #1 mikkom Technical User Jul 23, 2010 29 FI I have time in form: 14:14:52 (hh:mm:ss), 24 hours. How I can remove seconds (new form 14:14)?
Sep 28, 2011 #2 IanWaterman Programmer Jun 26, 2002 3,511 GB Right click time field and select appropriate time format from list. If Text and always HH:MM:SS you can use left trim left(timefield, 5) Ian Upvote 0 Downvote
Right click time field and select appropriate time format from list. If Text and always HH:MM:SS you can use left trim left(timefield, 5) Ian
Sep 28, 2011 Thread starter #3 mikkom Technical User Jul 23, 2010 29 FI Thanks! That was too easy solution, I could not think that. Upvote 0 Downvote