×
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.

Adding a decimal point to a number

Adding a decimal point to a number

(OP)
I have two fields:

{Coverage.TOTALHOURS} which displays as "1.00"

{Coverage.TOTALMINUTES} which displays as "30" - No decimal point

Formula is:
{Coverage.TOTALHOURS} + {Coverage.TOTALMINUTES}

Because the {Coverage.TOTALMINUTES} does not have a decimal point, it returns "31.00" - I need it to return "1.30"

How do I fix this?

Thanks for your help - Lynn

RE: Adding a decimal point to a number

If you need it to return 1.3 and not 1.5 (for 1 and a half hours) then
{Coverage.TOTALHOURS} + ({Coverage.TOTALMINUTES} / 100)

If you need it to return 1.5 (for 1 and a half hours) then
{Coverage.TOTALHOURS} + ({Coverage.TOTALMINUTES} / 60)

RE: Adding a decimal point to a number

(OP)
Great! That worked.

RE: Adding a decimal point to a number

zidol, you do realize that with a representation of 1.3 (1 hour, .3 x 100 minutes, cuz it's not 1.3 hours!) no one can use 1.3 to perform any meaningful math without handstands, backflips, explanations and disclaimers, yes?

Skip,

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

RE: Adding a decimal point to a number

(OP)
Yes - I do.

I meant to type 1.5 - but thanks!

RE: Adding a decimal point to a number

There's an Edit button for that.

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!