Im not sure if a nested IF/AND formula is the way to go or if to round it. But when I try to write the formula I get an error message.

Im trying to convert time into 1/10th increments of an hour for billing and account for rounding up or down. For example:

Less than 9 minutes = 0.1 of an hour (6 minutes)

9 minutes to 15 minutes = 0.2 of an hour (12 minutes)

15 minutes to 21 minutes = 0.3 of an hour (18 minutes)

And so on…

I need to write a formula that will read the duration (hh:mm) and round up or down to the nearest 1/10th increment in minutes.

Any help would be greatly appreciated!