Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm using the interval function to work out the period between two datetime values, in days and hours, as below:
Interval(ReloadTime() - L_DispatchRequestTime, 'd - hh')
Whilst this gives the correct results it looks very confusing. I'm looking to add my own custom labelling to the format so I can something like:
'1 day 5 hours'
Is there any way of adjusting the formatting so I can fully customise the labelling, or get the result above?
Thanks in advance.
Try something like this: =replace(replace(interval(1.55, 'd X - h Z'), 'X', 'day(s)'), 'Z', 'hours')
- Marcus
This works great, thanks.