Hinew field: elapsed time

[fmazzarelli]

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.

[MK_QSL]

Hour(Interval#('253 15:43','D hh:mm'))

Interval(Interval#('253 15:43','D hh:mm'),'D')

Replace '253 15:43' with ElapsedTime

[fmazzarelli]

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.

[fmazzarelli]

ok I solved

num(Interval(Interval#([DELTA],'D hh:mm'),'D')*24, '#####0')