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
96 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
  • 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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

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 45

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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
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…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

705 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now