Your log records elapsed minutes, but the summary rounds to the nearest quarter hour. Preserve the measured duration in its own column.
Test both sides of a rounding boundary
Put 7, 8, 22, and 23 in B2:B5. Enter =MROUND(B2,15) in C2 and fill down. Expect 0, 15, 15, and 30. If both 22 and 23 must go to 30 under your rule, the report calls for rounding up instead.

Illustrated nearest-multiple check. Keep a pair on each side of a boundary.
Confirm what the input unit represents
If B2 is a spreadsheet duration stored as a fraction of a day, multiply it by 1440 to get numeric minutes first. For example, 00:23 becomes 23 minutes. Keep the original value, and label the result Nearest 15 minutes so readers know which rule applies.

Illustrated unit check. Keep the raw duration beside the result.



