Your data is in sexagesimal format so you have to multiply by 24 as I indicated in my previous post.
Before stating " didn't work" please read and apply carefully what has been suggested.
Also check the placement of you parenthesis.
Something like =SUM(YOUR_RANGE*NUMBER) is not the same as =SUM(YOUR_RANGE)*NUMBER

Attached Files

Copy of Workbook3.xlsx (16.9 KB, 12 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post