Equivalent for excel time format 37:30:55

[IvaMaia]

Hi!

New to PBI, I need your help: I have a column of data imported from excel with waiting times. I had it in excel format 37:30:55, but it's lost in PBI - for a previous waiting time of 28:37:39, I get in PBI "01/01/1900 04:37:39", in text format. Changing the format to time, I'm left with 04:37:39, which is the wrong information. I saw the 2016 answer to the one previous post about this subject, but it doesn't quite fit what I need to do.

Appreciate all the help you can give me!

Thanks!!

Iva

[v-piga-msft]

Hi @IvaMaia,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share some data sample and your desired output so that we could help further on it.

Best Regards,

Cherry

[v-piga-msft]

Hi @IvaMaia,

Please refer to the similar threads below which has been solved.

https://community.powerbi.com/t5/Desktop/Problems-with-hours-greater-than-24-hours/td-p/112680

https://community.powerbi.com/t5/Desktop/PowerQuery-Duration-more-than-24-hours/td-p/267272

If you still need help, please feel free to ask.

Best Regards,

Cherry

[IvaMaia]

Hi!

Relatively new to PBI, I have a column of data imported from excel, with waiting times, that were in excel time format 37:30:55.

In PBI, in time format, all waiting times > 24 hours are lost -eg  28:00:00 hours of waiting, changes to 04:00:00.

Does anyone know how to get the equivalent to excel format 37:30:50 in PBI?

Thanks a lot for your help!

Iva

[Greg_Deckler]

Leave it as text ?