Hi,
You might try the following formula in P5 (and copy it down). It won't handle every possible thing you can throw at it, but it should handle a good number of them.
The first two formulas account for the standard time calculation you already had.
The third formula -- COUNT($B5:$O5)/2*(30/(60*24)) -- functions by counting the numbers in the row and dividing by two to determine the number of days. It then multiplies that number by 30 minutes (divided by 60*24 to convert it to days, which is the standard Excel method to store times). You will run into issues if you have odd numbers of times.
S
Bookmarks