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!

Register Log in
  • Congratulations SkipVought 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

mikkom

Technical User
Jul 23, 2010
29
0
0
FI
I have time in form: 14:14:52 (hh:mm:ss), 24 hours. How I can remove seconds (new form 14:14)?
 
Sort by date Sort by votes
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
Thanks! That was too easy solution, I could not think that.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

POrlowski
  • Locked
  • Question
Calculating Sick Time
Replies
7
Views
97
POrlowski
POrlowski
jchewsmith
  • Locked
  • Question
Formatting an embedded field in Crystal 2016 Support Pack 5 1
Replies
3
Views
93
BobSuruncle
BobSuruncle
nerdygirlgear
  • Locked
  • Question
Limit sub report records to a time range on main report 1
Replies
1
Views
41
hilfy
hilfy
GCL2007
  • Locked
  • Question
Formatting hyperlink on exported document
Replies
0
Views
41
GCL2007
GCL2007
GCL2007
  • Locked
  • Question
Date fields coming into Crystal as Date/Time 1
Replies
2
Views
65
GCL2007
GCL2007

Part and Inventory Search

Sponsor

Back
Top