Convert time format

[Anonymous]

Hello

in my excel file, I have data in the format hh: mm: ss that I want to transform in the format hh, m in the script when loading data.

today I can not transform my data into the desired format.

Thanks for your help

[sunny_talwar]

May be this

Time(Time#(FieldName, 'hh:mm:ss'), 'hh, m') as FieldName

[Anonymous]

Thank you but it does work, I have nothing in my new field...

[dwforest]

You may need to manually parse the data if it is formatted as General (string) rather than a date/time in Excel

Time(MakeTime(num(left(FieldName,2)), num(mid(FieldName,3,3))),'hh, m')

[Anil_Babu_Samineni]

today I can not transform my data into the desired format.

Not sure, I followed this part.

Perhaps this?

If FieldName = Today() Then

Load FieldName From Table;

Else

Load Time(Time#(FieldName, 'hh:mm:ss'), 'hh, m') as FieldName From Table;

End If;

[sunny_talwar]

Would you be able to share few rows of data to see your issue?

[Anonymous]

Here are some lines of my Excel file.

I have also some hours in the colum "Time" which are higher than 24:00:00 (max: 239:00:00)

I created the second column to be able to calculate the total.

Time            Time in hour

0:02:53	0,05
0:16:48	0,28
0:10:00	0,17
0:14:51	0,25
0:10:00	0,17
0:10:00	0,17
1:19:17	1,32
0:00:00	0,00
0:00:00	0,00

Thank you

[Anonymous]

No I doesn't work, I have "-" in my field

[sunny_talwar · Accepted solution]

Maybe try this

Num(Time)*24

[rwunderlich]

If you parse this using the Interval#() function it should be correct, even when hh>24.

Interval(Interval#(Time, 'h:mm:ss'))

Can you post the script you are trying?

-Rob