<div>
That worked great. &nbsp;Thanks!
</div>


<div>
You're welcome. You're welcome. You're welcome. You're welcome. :-)<br />
<br />
To close the question, please click &quot;Accept solution&quot; on my previous comment.
</div>


You're welcome. You're welcome. You're welcome. You're welcome. :-)

To close the question, please click "Accept solution" on my previous comment.

<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
I have a date time field that I need to split into a date and a time field, and I also have to change the time from hours, minutes and seconds into total seconds, based on hours minutes and seconds. &nbsp;THe system that I am importing data into does not use hours minutes and seconds, just seconds.<br />
<br />
I will be formatting the data in excel and then importing.
</div>
</div>


I have a date time field that I need to split into a date and a time field, and I also have to change the time from hours, minutes and seconds into total seconds, based on hours minutes and seconds.  THe system that I am importing data into does not use hours minutes and seconds, just seconds.

I will be formatting the data in excel and then importing.

how do I convert a date time field to a date field and the time section into seconds instead of hours, minutes and seconds

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.