Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
angmarceau1971
Contributor III
Contributor III

Converting Minutes UTC to different TimeZones

I've been trying to figure out this formula and I'm stuck.   

I'm pulling data in where i have a starttime and endtime which is in UTC minutes.  I need to covert that to different timezones based on each record.  Sample data below.

 

2023-03-31_9-08-21.jpg

 

 

I need to display start and end time in hh:mm TT format.   Here is where I think I've gotten the closest one to work.  But for some reason, it's not displaying the correct AM/PM time?  

Need help identifying what I'm doing wrong.   Below is what i have in START_TIME3, which seems to be cluse, but just not exactly right.

Date(ConvertToLocalTime(Time(startMinuteOfDay/(60*24), 'hh:mm TT'),'Central Time (US & Canada)',FALSE()),'hh:mm TT')

 

Labels (1)
1 Reply
sandeep-singh
Creator II
Creator II

Try this

ConvertToLocalTime((startMinuteOfDay),'Central Time (US & Canada)',False())

In the column - Number Formatting -> Duration -> format pattern 'hh:mm TT'