Navigation
Search
|
How Do I Pick the Earliest and Latest Time In a Range Of Dates In Numbers?
Saturday January 26, 2019. 07:25 PM , from MacMost
I have a Numbers spreadsheet in which I enter items based on Date and Time. So the list might look like this(although in reality I usually have about 10 items per day):
Fri, 25 Jan 2019 09:00 Fri, 25 Jan 2019 10:00 Fri, 25 Jan 2019 14:00 Sat, 26 Jan 2019 11:00 Sat, 26 Jan 2019 15:00 Sat, 26 Jan 2019 16:00 As a basic request, I want to pick the earliest and latest time on the latest date. I can pick the latest time on the latest date by using the MAX function or the earliest time on the earliest date by using the MIN function but otherwise I am struggling. As a bonus request, is there a way of picking the earliest and latest times for each and every day? —– Jon E
https://macmost.com/forum-how-do-i-pick-the-earliest-and-latest-time-in-a-range-of-dates-in-numbers....
|
46 sources
Current Date
Nov, Fri 22 - 06:44 CET
|