Converting time (MM/DD/YYYY plus HH:MM:SS) to just seconds

[sshellan]

I have an excel spreadsheet with over 22,000 rows. Each row describes where a deer with a GPS collar was standing at a given time. I need to convert the time data, which is in Zulu, to time data that I can use arithmetically. I'm not sure what this unit is called, but seconds since Jan 1st 1900 sounds good to me.

In my spreadsheet, time is represented by column E in this format: MM/DD/YYY; and column F in this format: HH:MM:SS.

How can I create one time, in seconds since Jan 1st 1900, from these two columns? I am hoping for a marvelous macro.

 

[footoo]

Macro not necessary.
Assuming that the value of each date in column E is as of 12:00am, and the value of each time in column F is a fraction of one day, then :-
=(E1+F1)*86400

 

[MARK858]

Strictly speaking because Excel thinks that the year 1900 was a leap year (when it wasn't) then the number of seconds since 1/1/1900 would be

=(E1+F1)*86400-86400

But it probably doesn't make any difference in this case

 

[sshellan]

Thanks guys, it worked!

My only hiccough was having to make sure the cell was formatted as a number.