Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formatting time

Status
Not open for further replies.

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)?
 
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

 
Thanks! That was too easy solution, I could not think that.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top