×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

# Help converting data from SQL table

## Help converting data from SQL table

(OP)
Good Morning.. I'm using crystal to report off a sql database.. there is a duration field which is minutes but it pulls x,xxx,xxx.xx with a formula how do I convert that to minutes?

thanks for any help!! conversions make my head hurt

### RE: Help converting data from SQL table

Hi,

Are you saying that your duration in minutes field displays as millions to two decimal places?

So are you expecting to see duration on the order of camera shutter speeds or the amount of time it takes to walk around the block or the time it would take a space ship to get to the nearest star or on the order of what?

If the duration is displayed in minutes, then to convert to minutes you multiply by 1.

Skip,

Just traded in my OLD subtlety...
for a NUance!

### RE: Help converting data from SQL table

(OP)
For example.. a duration field shows 5 minutes on the form.. the sql table is showing 300,000.00 when i report from crystal.. how do i convert the field to show 5 instead?

### RE: Help converting data from SQL table

Well, your original question was very impossible to understand, with x,xxx,xxx.xx which could have been ANYTHING.

Skip,

Just traded in my OLD subtlety...
for a NUance!

(OP)

### RE: Help converting data from SQL table

By deduction there are ...

5 minutes * 60 seconds/minute = 300 seconds

1000 milliseconds/second * 300 seconds = 300,000 milliseconds.

Skip,

Just traded in my OLD subtlety...
for a NUance!

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Close Box

# Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!