Time Value Clean-up?

[Mabel_dlp_999]

I'm looking for the best way to clean my time data into one column. For this example, I have two columns.

Coulmn 1 is an integer between 1 and 24
Coulmn 2 is a text string that equals either Hours, Days, or Weeks

Example 1: In row 1, Col1 = 3 & Col 2 = Hours--> This would be 3 Hours
Example 2: In row 2, Col1 = 2 & Col2 = Days --> This would be 2 Days
Example 3: In row 3, Col1 = 4 & Col2 = Weeks --> This would be 4 Weeks

I know I could just merge the two together columns, but I'm concered doing so may not work with measures I create off this data. Any suggestions?

[Mabel_dlp_999]

@Greg_Deckler Thanks so much for the speedy answer! You're the bomb, I was able to create a new column to show everything in terms of hours. 

Thanks again!

[Greg_Deckler · Accepted solution]

@Mabel_dlp_999 I would pick a time granularity and just convert everything into hours, minutes, or seconds for example.