Add time since 1900

[belebala]

I'm new to Power BI/Power Query and need some help.

I connected Power BI to my database server and there is a field that I need to convert to date/time.

The database stored the minute as the number of minutes since 24:00 on 31/12/1900. For example, 00:01 am on 01/01/1901 =1.

I need to convert 62252640 to 13/5/219 00:00am in a new column, but I don't know how to edit it in Power Query.

Thanks in advance.

 

[Matt Allington]

This is pretty common. Just convert the seconds to days /60 /60 /24. You can then convert the days to a date by changing the data type.

 

[belebala]

Hi Matt,

Thanks for getting back to me. Here is what I did: [Start_min]/60/60/24 and changed to date data type. But something went wrong, for example, [start_min] of 59973510 returned 1901-11-24 3:18 instead it should return 2015-01-11 6:30. I tried adding 19010101 after the division, but it returned error. Am I missing something?

Thanks