Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Eariliest data and time
What formula will identify the cell that contains the earliest date and time?
Here is a sample of my spreadsheet: B2 contains: 2015:12:25 14:01:38 C2 contains: 2016:04:23 06:49:44 D2 contains: 2016:04:23 06:49:44 E2 contains: 2015:12:25 14:43:31 F2 contains: 2015:12:25 14:43:31 G2 contains: 2015:12:25 14:43:31 Note: One to four of the cells in each row may be empty |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Eariliest data and time
The data is the EXIF data in .jpg and .png files.
The columns are, respectively: FileModifyDate FileAccessDate FileCreateDate ModifyDate DateTimeOriginal CreateDate |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose 4 Columns data to Rows for Employee Time In and Time Out Schedule | Excel Programming | |||
Adding multiple data fields from time based data. | Excel Discussion (Misc queries) | |||
data reduction--goal:unique time data only | Excel Programming | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |