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

Number to Time Conversion

Status
Not open for further replies.
Robin99

Robin99

Technical User
Apr 8, 2004
19
0
0
US
CR Version 7
DB = Encore/Impact/Syspro 5.1 ODBC

Hello,

I'm working with a Transaction Time field that returns time values like: 8311576 and 10125494.
CR Field Type is: Number

How can I convert the above values into an HH:MM format?

Thanks as always for the help.

Robin
 
Status
Not open for further replies.

Similar threads

POrlowski
  • Locked
  • Question
Calculating Sick Time
Replies
7
Views
105
POrlowski
POrlowski
mmck1964
  • Question
Using "OR" to select data
Replies
4
Views
177
mmck1964
mmck1964
socalvelo
  • Locked
  • Question
Limiting the number of records in groups and sub-reports 1
Replies
2
Views
66
socalvelo
socalvelo
Brian S
  • Locked
  • Question
Splitting names that have variable numbers of spaces 1
Replies
5
Views
94
Brian S
Brian S
Tichaona
  • Locked
  • Question
Row numbering formula not working
Replies
4
Views
101
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top