Solved

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

Posted on 2014-10-18
8
118 Views
Last Modified: 2014-11-23
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.
0
Comment
Question by:sannunzi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
8 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40389340
Date

=int(a1)

Time

=(a1-int(a1))*24*60*60

Make sure you format the date answer as a date, otherwise it will look like a 5 digit number
0
 

Author Comment

by:sannunzi
ID: 40389442
That worked great.  Thanks!
0
 

Author Comment

by:sannunzi
ID: 40389443
That worked great.  Thanks!
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:sannunzi
ID: 40389444
That worked great.  Thanks!
0
 

Author Comment

by:sannunzi
ID: 40389445
That worked great.  Thanks!
0
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40391475
You're welcome. You're welcome. You're welcome. You're welcome. :-)

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

Expert Comment

by:Martin Liss
ID: 40460434
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question