Hi all
I'm importing a CSV file with a column called 'Core Time'. This has a few time values in it with are over 24hrs long. I've tried formatting this column to [h]:mm in the source data however that doesn't help.
When imported into PQ I get this error:
Expression.Error: We couldn't parse the input provided as a Time value.
Details:
24:39:00
Trying to change type to duration doesn't help. What do I need to so that these times are preserved?
Thanks in advance!
I'm importing a CSV file with a column called 'Core Time'. This has a few time values in it with are over 24hrs long. I've tried formatting this column to [h]:mm in the source data however that doesn't help.
When imported into PQ I get this error:
Expression.Error: We couldn't parse the input provided as a Time value.
Details:
24:39:00
Trying to change type to duration doesn't help. What do I need to so that these times are preserved?
Thanks in advance!