Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Interval Formatting incl. Description

Hi,

i have a formula with an interval statement which got a formatting 'dd:hh:mm'. Everything works fine. But i need a description of Days in my chart.

At the moment, for example my chart looks like '22:20:03' but now i want to have it like this way '22 Days 20 hours 03 Minutes'.

Is that possible?

Greetings

2 Replies
Gysbert_Wassenaar

Floor(MyInterval) & ' Days' &  Hour(MyInterval) & ' Hours' & Minute(MyInterval) & ' Minutes'


talk is cheap, supply exceeds demand
Not applicable
Author

When I write ' Days' behind the first part of the formula, in my chart there are no values. But for example '%' works...