Navigation
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....
|
59 sources (15 en français)
Date Actuelle
ven. 22 nov. - 12:36 CET
|