Adding Multiple column

[Guest123465]

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

[try67]

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.

[Guest123465]

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

[try67]

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

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

[Guest123465]

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

[try67]

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.

[Nesa Nurani]

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

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

[Guest123465]

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