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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Showing "short time"

Status
Not open for further replies.
air1jcw

air1jcw

Technical User
Jan 23, 2003
30
US
I have a field that is of "number" data type. The data shows up as 123. I need to show the data as 01:23. I cannot not change the data type because the data is transfered from a .txt file. Changing the data type corrupts the data. Some of the data shows up as 1256. Whick I need for it to show as 12:56 (Military Time). Can somebody help me out??

Thanks
air1jcw
 
Sort by date Sort by votes
left(right('000' & cstr(data),4),2) & ':' &
right(right('000' & cstr(data),4),2)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
180
OzFoxy
OzFoxy
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
748
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Select addresses using two criteria, one 'Like" 2
Replies
3
Views
443
TrekBiker
TrekBiker
WimDC
  • Locked
  • Question
Help on grouping by TIME Range
Replies
1
Views
339
dhookom
dhookom
ptrifile
  • Locked
  • Question
Change Date/Time Field 1
Replies
5
Views
242
ptrifile
ptrifile

Part and Inventory Search

Sponsor

Back
Top