Convert days format to Hours

[Shahzad_Ahsan]

Hi

I have "Time" field in the database with below format :

2 days 11:10:05 

I need to convert the days in hours.

The result should be 59:10:05

Thanks

[Taoufiq_Zarra · Accepted solution]

@Shahzad_Ahsan  One option:

subfield(Time,'days',1)*24+subfield(subfield(Time,'days',2),':',1)&':'&subfield(subfield(Time,'days',2),':',2)&':'&subfield(subfield(Time,'days',2),':',3)

like for example :

Data:

load *,
subfield(Time,'days',1)*24+subfield(subfield(Time,'days',2),':',1)&':'&subfield(subfield(Time,'days',2),':',2)&':'&subfield(subfield(Time,'days',2),':',3) as NewTime inline [
Time
2 days 11:10:05
3 days 12:30:55
];

output:

[Shahzad_Ahsan]

Thank You @Taoufiq_Zarra 

Its working. 😊