topic how to show hrs and mins string values with result for Interval time in App Development

how to show hrs and mins string values with result for Interval time

harish_meda — Tue, 21 Dec 2021 20:02:52 GMT

Hi All,

I have start date and end date

stdate:2021-02-22 00:07:00

Endate :2021-02-22 04:24:08

Interval(date('2021-02-22 04:24:08'-'2021-02-22 00:07:00'),'hh:mm')-->Result is " 04:17".

now i need to display hrs after 04 and mins after 17 ,Like" 04hrs:17Mins"

Re: how to show hrs and mins string values with result for Interval time

jwjackso — Tue, 23 Mar 2021 21:39:38 GMT

Using the data below:

Data:
Load *,
Interval(date(enddate-stdate),'hh:mm') as I1,
Num(Interval(date(enddate-stdate),'hh')*24,'00')&'hrs:'&Num(Frac(Num#(Interval(date(enddate-stdate),'mm'))/60) * 60,'00')&'mins' as I2;
Load * Inline [
stdate,enddate
2021-02-22 00:07:00,2021-02-22 04:24:08
];