MacMusic  |  PcMusic  |  440 Software  |  440 Forums  |  440TV  |  Zicos
latest
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....
News copyright owned by their original publishers | Copyright © 2004 - 2024 Zicos / 440Network
Current Date
Nov, Fri 22 - 06:44 CET