I can't really tell your exact problem because I can't see the underlying data or what you have going on in that calculation. Here is a quick sample with some dates and times in separate columns from Excel.
I first created a Date Time field:
DATETIME(str([Date]) + " " + [Time])
Then I extracted the hour from the Date Time:
9.2 workbook attached.
Hour.twbx 98.2 KB
Thanks for the reply. sorry I forgot to add my data.
Here's a screenshot of my excel sheet
They're all formatted correctly.
I want this to look like this:
but in time format hh:mm:ss. (the above picture is a different type of data. it's calls answered so the data is in whole number so it is straight forward drag and drop in tableau.).
Do I have to make a calculated field before I drag it in?
Sorry it is kind of hard to help with partial screenshots.
Take a look at this thread. You might need to turn everything into seconds to make that work: