Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 21st 17, 06:38 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2017
Posts: 4
Default 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   Report Post  
Old June 21st 17, 07:06 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2017
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transpose 4 Columns data to Rows for Employee Time In and Time Out Schedule Nasir[_2_] Excel Programming 0 May 4th 11 12:05 PM
Adding multiple data fields from time based data. JMK Excel Discussion (Misc queries) 1 July 27th 07 10:59 PM
data reduction--goal:unique time data only ERC Excel Programming 6 February 2nd 06 11:34 PM
time formatting and time categorizing (vlookup or data validation) MarianneR Excel Worksheet Functions 4 November 18th 04 03:24 PM
time formatting and time categorizing (vlookup or data validation) MarianneR Excel Worksheet Functions 0 November 18th 04 03:13 PM


All times are GMT +1. The time now is 04:48 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017