I have a project where I need to ADD TIME. Under normal circumstances, it wouldn't be a problem. However, in some cases, I may need to have totals that exceed 24 hours. So, I need 2 forumlas.

First, I need a formula that will add the total time in hours taking into account the start/end dates.

Second, I need a formula that will add all the resulting hours.

Keep in mind that this EXAMPLE is very minimal and I may have 70 line items.

Can anyone help me out here?

Thanks!