Question

Days to hours

Forms

Updated March 20, 2020

asked on March 20, 2020 • Show version history

Hello,

I have a Single line field which does calculations & gives no. of days, i want that another field should represent this value in hours.

1 day should be equal to 8.5 hours.

Both fields are part of Table.

Can someone help, please?

Regards,

0 0

Answer

SELECTED ANSWER

replied on March 20, 2020

Hi Sonia

I recommend you use Number fields for both fields.

As both fields are in your Table, in your Hours field you could use either of the following.

These formula's react slightly different so you may want to test both

I find it best to use the token picker to insert the field into the formula (Tablename.Variablename would be the Days field)

=PRODUCT(INDEX(Tablename.Variablename,ROW()),8.5)

=MULT(INDEX(Tablename.Variablename1,ROW()),8.5)

1 0

replied on March 20, 2020 • Show version history

Works!!!

Thanks!

0 0

Replies

replied on March 20, 2020

This post should help you out. You would want to take the product of your days field and multiply that by 8.5. This formula would go in the field you want was your days field.

https://answers.laserfiche.com/questions/126787/Multiplying-Formula-in-Forms

0 0

You are not allowed to follow up in this post.

Question

Question

Days to hours

Answer

Replies

Sign in to reply to this post.