Jump to content

Transform separate Date and Time columns

Michael Palmer 2

Recommended Posts

I have a column of data that is Date (YYYY/MM/DD) and a column of data that is Time (HH:MM:SS)

I am trying to get this into Unix or something where I can get total hours for a range of data, or cumulative hours for specific data, change in hours, etc.

im not sure how to do this in spotfire. In excel I combine the two columns into one column and then get it into a numerical value.

I know I can change in excel and then import into spotfire but I want to skip that step, and the formulas aren't all the same between excel and spotfire. I need this to be in a way where I can drop in new excel worksheets.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...