Tableau Tutorial - Convert String to Time (MAKETIME, LEFT, MID, RIGHT, INT, IF-THEN, custom format)

[@bellaking8352]

Your videos are my reference library. you are wonderful with your explanations.

[@TableauWeston]

Glad you like them! Thanks for watching.

[@srinuvenkata8567]

You have made a great video. Thank you

[@TableauWeston]

Glad you enjoyed it!

[@fatbean87]

thanks a lot! this helped a lot! finally found the solution after googling for so long!

[@TableauWeston]

Great to hear!

[@masonperry538]

Worked like a charm! Appreciate the help!

[@TableauWeston]

Awesome!

[@lorynhartbarger9252]

Thanks! What if I wanted to show a range of time? For example 12:30PM to 1:00PM.

[@TableauWeston]

Essentially you would create two strings - one for the starting time and one for the ending time. Then create a calculated field with a formula similar to [starting time] & "to" & [ending time]. You may have to use"+" rather than "&", but you get the idea. Thanks for watching.

[@yashshah699]

Thank You for making this video. It helped a lot :)

[@yashshah699]

Hi, Every thing seems to work fine except "10"/"11"/"12":PM. For eg, If the original clock In/Out is 10 PM, than the New Clock In/Out will show 10 AM which is wrong. Do you think we can adjust something in the formula to accommodate this? Thank You

[@andynina63123]

Thank you very much

[@bbqyou1325]

Hi Weston, when I use tableau, maketime isn't appearing as a function

[@TableauWeston]

What version of Tableau do you have? That's weird MAKETIME isn't showing up. Have you looked at the formula help section? (Grey section to the right of the calculated field edit screen.)

[@kingazabicka]

Thank you for poor students!

[@izedortsac302]

Helpful

[@TableauWeston]

Glad you think so!

[@shaquellejacobs9820]

WHAT IF I HAVE HR:MIN:SEC

[@TableauWeston]

I think you can use the same approach. You may need FINDNTH to find the second colon, but you can still use the MAKETIME function to add seconds.