## How to sum time values sorted by month/year?

314 Views 5 Replies Latest reply: Jan 16, 2013 1:12 PM by Jerrold Green1
Calculating status...
Currently Being Moderated
Jan 16, 2013 9:53 AM

I would like to sum time values that are sorted by month/year. (Concept is based on a pilot's logbook)

In Table 1, Column A is a date; Column B is the associated time value (duration).

In Table 2, I would like to Sum the time value of Table 1 Column B by month an year.

TABLE 1

Jan 1, 2013

2:30
Jan 3, 20134:15
Jan 9, 20133:55
Feb 2, 20135:01
Feb 10, 20131:33
March 3, 20135:55

TABLE 2

Jan-1310:40
Feb-136:34
Mar-135:55
Apr-13

iMac, iOS 6.0.2
• Level 7 (27,430 points)
Currently Being Moderated
Jan 16, 2013 10:30 AM (in response to smash09)

smash,

Here's an example of what can be done:

The formula in the Total column of Summary is:

=SUMIFS(Log :: B, Log :: A, ">="&A, Log :: A, "<"&EOMONTH(A, 0)+1)

The Month column of Summary is filled with a series of dates that can be formatted as Jan-13, etc, if you wish.

I used the 0h 0m format for the Durations to distinguish it from times.

Jerry

• Level 7 (27,430 points)
Currently Being Moderated
Jan 16, 2013 12:58 PM (in response to smash09)

smash,

What that tells me is that your Column A entries were not interpreted as Date Values in the summary table. A way to test this is to try a different format on that column. If you can change the format, you are working with date values. If not, the dates are being interpreted as text.

Jerry

• Level 7 (27,430 points)
Currently Being Moderated
Jan 16, 2013 1:12 PM (in response to smash09)

it never hurts to whack the malfunctioning appliance on the side of the case.

Jerry

#### More Like This

• Retrieving data ...

#### Legend

• This solved my question - 10 points
• This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.