Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
having a field called Elapsed time with the value of 253 15:43 (format day hh:mm)
253.............. day
15................ hh
43 .............. mm
How could i create 2 new fields? (day , hh)
I'm using
day(ElapsedTime)
hour(ElapsedTime)
but doesn't work.
Hour(Interval#('253 15:43','D hh:mm'))
Interval(Interval#('253 15:43','D hh:mm'),'D')
Replace '253 15:43' with ElapsedTime
Hi
a curiosity, converting the days in hh
I get a result with decimals
example
Formula:
=(Interval(Interval#([DELTA],'D hh:mm'),'D')*24
Result
1320,0666667 instead of 1320
May I fix a number with no decimals?
I tried
num((Interval(Interval#([DELTA],'D hh:mm'),'D')*24 , '#####0)
but doesn't work.
ok I solved
num(Interval(Interval#([DELTA],'D hh:mm'),'D')*24, '#####0')