Round up a time to nearest 15 mins and display as 1 hour 30 mins

[qliklizzy]

Hi 

i have seached this site to come up with the below but i need extra help mixing them together - please?

i have this expression which gives me the display  i need:

=replace(replace(interval(max({<MetricDesc=,MetricID={'LI01'},
Location={'Minors','ADULT MIN'},
SeenByPractitioner={'No'},Status={'DOC/PRAC','REG','WAIT CUB'}>}
AETotalWait)/24/60,'h X - m Z'), 'X', 'hours'), 'Z', 'mins')

and i have this that gives me the round up I need:

=Time(interval#(ceil(num#(text(interval(max({<MetricDesc=,MetricID={'LI01'},
Location={'AM','MAJORS','ADULT AM','AMB/STAT'},
SeenByPractitioner={'No'},Status={'DOC/PRAC','REG','WAIT CUB'}>}
AETotalWait)/24/60, 'mm'))),15),'m'))

how do i combine them both so i get  a time stamp in the 1 hour 30 min display even if my time is 1 hour 25 so its rounded up. 

[qliklizzy · Accepted solution]

ive done it!! :):):)

=replace(replace(interval(Time(interval#(ceil(num#(text(interval(max({<MetricDesc=,MetricID={'LI01'},
Location={'Minors','ADULT MIN'},
SeenByPractitioner={'No'},Status={'DOC/PRAC','REG','WAIT CUB'}>}
AETotalWait)/24/60, 'mm'))),15),'m')) ,'h X - m Z'), 'X', 'hours'), 'Z', 'mins')