Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Adding Multiple column

New Here ,
Mar 13, 2023 Mar 13, 2023

i've Searched thru many post for calculating multiple columns.Can any one help me to solve this.

I need to calculate 9 columns and show the result in the 10 column.  I am calculating for business working hour. I need to convert (15 min => 25, 30 Min => 50, 45  min =>75).

 

image.pngexpand image

 

TOPICS
How to , JavaScript , PDF forms
1.5K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 13, 2023 Mar 13, 2023

That's a lot of information missing here...

What type of values do these fields have? Numbers (if so, representing what?) / Dates (if so, in which format?) / Times (if so, in which format?) / Something else?

Which values do you want to round up? Each field or just the result?

Also, your rules for rounding are not very clear. Please clarify.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 13, 2023 Mar 13, 2023

All the field are in number in format with 2 decimal places 1.234,56

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 13, 2023 Mar 13, 2023

OK, but I still don't follow your rounding rules...

Please specify it in ranges: X-Y should become Z.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 13, 2023 Mar 13, 2023

mon-time1 =>02:15

mon-time2=>03:30.

i need to add this and convert them to fractional value

the sum of mon-time1+mon-time2=5.45. but i need it as 5.75

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 13, 2023 Mar 13, 2023
LATEST

These are not numbers, as you wrote earlier... Are these time notations? If so, what you wrote doesn't make sense, as "5.75" is actually 6:15.

And you still didn't specify the logic behind the rounding.

 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 13, 2023 Mar 13, 2023

Why not use the built-in function to sum values?

If values are numbers, what's about converting minutes?

 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 13, 2023 Mar 13, 2023

I need to convert it into business hours .

(15 min => 24 , 25 min => 50, 45min = >75).

i cannot able to do this by build-in sum values

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines