topic Re: Convert Time into minute in App Development

Convert Time into minute

gauravgg — Mon, 14 Nov 2016 16:01:00 GMT

i have field as follows

Time

1Day20Hrs30Min25Sec

2Day20Hrs45Min25Sec

1Day24Hrs30Min25Sec

1Day16Hrs30Min25Sec

3Day14Hrs30Min25Sec

I want to convert the above field into HH:MM:SS

Can anyone help me?

Thanks in advance

Re: Convert Time into minute

Anonymous — Mon, 14 Nov 2016 16:14:55 GMT

Hi,

What do you want to see ? Something like this :

1Day20Hrs30Min25Sec = 44:30:25

2Day20Hrs45Min25Sec = 68:45:25

Re: Convert Time into minute

antoniotiman — Mon, 14 Nov 2016 16:24:15 GMT

Hi Gourav

=SubField('1Day20Hrs30Min25Sec','Day',1)*24+TextBetween('1Day20Hrs30Min25Sec','Day','Hrs')&':'
&TextBetween('1Day20Hrs30Min25Sec','Hrs','Min')&':'&TextBetween('1Day20Hrs30Min25Sec','Min','Sec') -> 44:30:25

Regards,

Antonio

Re: Convert Time into minute

sunny_talwar — Mon, 14 Nov 2016 16:29:32 GMT

I would also add the interval#() function to assign the timestamp a dual representation

Interval#(SubField('1Day20Hrs30Min25Sec','Day',1)*24+TextBetween('1Day20Hrs30Min25Sec','Day','Hrs')&':'

&TextBetween('1Day20Hrs30Min25Sec','Hrs','Min')&':'&TextBetween('1Day20Hrs30Min25Sec','Min','Sec'), 'hh:mm:ss')

Re: Convert Time into minute

migueldelval — Mon, 14 Nov 2016 16:31:57 GMT

Hi Gaurav,

Try this example

Regards

Miguel del Valle

Re: Convert Time into minute

gauravgg — Mon, 14 Nov 2016 17:10:56 GMT

yes

Re: Convert Time into minute

gauravgg — Mon, 14 Nov 2016 17:30:05 GMT

Hi sunny

this code is hard code ,

their are multipal rows in the table , How we can apply for all rows in that field

Re: Convert Time into minute

sunny_talwar — Mon, 14 Nov 2016 17:40:32 GMT

I guess Antonio‌ and I meant for you to replace the hard-coded values with the field name:

Interval#(SubField(FieldName,'Day',1)*24+TextBetween(FieldName,'Day','Hrs')&':'

&TextBetween(FieldName,'Hrs','Min')&':'&TextBetween(FieldName,'Min','Sec'), 'hh:mm:ss')