Adding a decimal point to a number 1

[zidol]

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

 

[AndyMc]

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

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

 

[zidol]

Great! That worked.

Thanks for your help.

 

[SkipVought]

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,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[zidol]

Yes - I do.

I meant to type 1.5 - but thanks!

 

[SkipVought]

There's an Edit button for that.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]