Time format with days

[Anonymous]

Hi Guys,

I'm trying to show the spent time in several tasks in a graph but I can't get the format that I need.

I want to show the numbers with days, hours and minutes, but when the time is more than a day, only I can show the hours and minutes.

Thanks a lot

[Colin-Albert]

What defines a day for your problem?

Is a day 24 hours, or a working day of say 8 hours.

Can you provide some examples of the start and end data showing the expected output?

[Anonymous]

Hi Colin,

Is a day of 24 hour

[jmvilaplanap]

Hi,

You can try with:

if(floor(sum(Time)) > 0, num(floor(sum(Time)), '#,### days' )) & ' ' & Time(sum(Time), 'hh:mm')

With this, you could see: x days 22:33

[Anonymous]

Hi Jose,

This solution works, but I can't use it in chart objects, only in texts,

There is no way to do something like time(mytime, 'dd Days, hh:mm');

Regards

[chris_johnson]

Hi,

You could try looking at the interval() function, I think this might help get what you want (although I've not tried it myself):

Interval ‒ QlikView

The examples seem to suggest you can separate days out

[Anonymous]

Hi Adam,

This almost works, but is not possible to write the word "Days" inside the format. Because D is like a day(numeric), y as year and s as second.

There are not escape characters?

Thanks

[antoniotiman · Accepted solution]

Hi Maikel,

to get 'Days' in Text try like yhis

Replace(Date(date,'DD/MM/YYYY'&' @'),'@','Days')

Regards,

Antonio

[Anonymous]

Great workaround Antonio!