Michael Palmer 2 Posted November 21, 2019 Share Posted November 21, 2019 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 More sharing options...
Gaia Paolini Posted November 25, 2019 Share Posted November 25, 2019 Assuming your date is of data type Date, and your time is of data type Time, then this should work DateTime(DateAdd([MyDate],TimeSpan([MyTime]))) if not, please post example data within a dxp so we can see the data types in Spotfire Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now