MacMusic  |  PcMusic  |  440 Software  |  440 Forums  |  440TV  |  Zicos
latest
Recherche

How Do I Pick the Earliest and Latest Time In a Range Of Dates In Numbers?

samedi 26 janvier 2019, 19:25 , par 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
Date Actuelle
ven. 19 avril - 13:27 CEST