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!