I want to calculating the chargeable hours on Number.

I added a new row to make the formula easier. You can hide that row after it is all set up.

B2 =STRIPDURATION(B1)×24

B3 =IFS(B2=0,0,B2<1,1,ROUND(MOD(B2,1)×60,0)≥10,INT(B2)+1,TRUE,INT(B2))

fill across with both to column J

K3 =SUM(B3:J3)

For row 3, fix the formatting so it isn't 3 decimals. Make them all auto. That was a mistake in my screenshot.

For hours>0, you stated that if min<10 then it is just the hours and if min>10 then it is hours+1 but you did not say what to do if min=10 exactly. The formula given above says if min>=10 then hours+1.

Note that, probably due to computer math not being perfect (base 10 decimal numbers translated to Base 2 for the computer sometimes have extremely small errors), STRIPDURATION*24 will turn hours + 10 minutes into the decimal equivalent of hours + 10.0000000000002 minutes. The ROUND function in the row 3 formula rounds it back to an integer number of minutes.

This (I think) gives same results with possibly slightly easier to follow formula:

In B2. filled right to col J:

=DUR2HOURS(B1)

This simply converts the Duration to decimal hours.

In B3, filled right to col J:

=IF(AND(B2>0,B2≤1),1,IF(MOD(B2,1)>10/60,INT(B2)+1,INT(B2)))

Explanation:

The IF(AND(B2>0,B2≤1),1 handles the case where the time spent on site is greater than 0 but less than or equal to an hour.

The second IF nested within the first handles the cases where the time spent is greater than an hour (or is 0).

The IF(MOD(B2,1)>10/60 checks if more than 10 minutes past the hour.

If yes, get the number of whole hours with INT and add 1.

If no, get the number of whole hours with INT but don't add 1.

SG