Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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')
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')