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
116 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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What is wrong with this Excel formula with an IF statement? 6 35
Outlook 2013 Contacts - comma-separated-field 20 36
split data by day 21 35
Pull Phone Number out of Cell 3 12
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

730 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