Rhyous

January 5, 2010

How to convert a number of seconds to a time format?

Filed under: QlikView — J. Abram barneck @ 11:44 am

Ok, lets say you have a table with seconds in it.

TimeInSeconds
10
199
765
402
398
107
40

First use this function to convert it to a time based number:

Time#(TimeInSeconds,’ss’)

Second, wrap that

Time(Time#(TimeInSeconds,’ss’), ‘m:ss’)

Now your table will look like this:

TimeInSeconds
0:10
3:19
12:45
6:42
6:38
1:47
0:40

While there is more to this, as you will see with a wide range of data, this should get you started and you should be able to go from here.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: