Adding DateDiff Values

[MikeyMo]

RE: Time tracking application, or at least my attempt at one. I need to calculate the total number of hours that a person was present. Very similar to punching a clock.

• I have two sets of dates/times that are added via a timestamp function.
• I have two DateDiff functions set up in an array to calculate the difference between in each set. A1(in) and B1(out) one set. C1(in) and D1(out) are the other.

I can get the individual number of hours for each set, but I don't know how to display the combined totals ((A1+B1) + (C1+D1) in col E.

Suggestions/solutions?

Thanks.
Mike

 

[MikeyMo]

I made a mistake in my explanation. What I meant to write was...

I can get the individual number of hours for each set, but I don't know how to display the combined totals - Diff((A1/B1) + Diff(C1/D1) in col E, which would give me the total hours someone was present.