Convert hours to date

[skzwane01]

Hi,

I have an excel data file which has the below data and I would like to convert the data into date format.

TriggerDate

07:06.9

18:02.4

23:11.4

21:34.0

52:13.9

29:33.5

Please kindly assist.

Kind Regards,

Sanele Zwane

[mrtinsjoao]

In Script Date(TriggerDate,'DD/MM/YYYY') as TriggerDate

[Vegar]

Which output do you expect from the TriggerDate samples above?