Numbers: How to do a filter on time in a time-sheet?

How about giving us an example?

Jerry

Hi harild,

You can filter on Durations.

Regards,

Ian

Hi Harild,

What cell formats are in your table? When I copy and paste your table into Numbers, the cells show Automatic format with no Date & Time options. How are you entering the date and time?

Numbers has a Date & Time format (a moment in time since midnight at the start of 1st January 1904).

More information will help towards a solution 🙂.

Regards,

Ian.

Harild,

Here's an approach that will work for you, if you don't mind adding a column.

I am using your example in my screen shot. I have had to change your dates to reflect my region's date format, but that shouldn't cause you any difficulty. I chose the format I did because it is unambiguous, but any format that works on your localization is fine. I chose to show that time of day in the Date field to make the point that there is no such thing in Numbers as a Date without a time, but if you fail to enter the time in the date field, midnight will be assumed. You don't have to show the time there in your working document. Just format Time to None.

Furthermore, a Time of Day entered without a Date is assumed to have the Date of the day on which the entry was made. In order to bypass any troubles that this might cause, I add a column to convert the Time of Day to a Day Fraction, and then multiply the day fraction by 24 to get decimal hours.

Now you can treat your times as pure numeric values. For 8:00 am, just enter 8 in the filter field, and so forth. The Hours Past midnight field does not have to be shown, so feel free to hide it.

Does this solve your problem?

Jerry