Add time since 1900

belebala

New Member
Joined
Apr 10, 2012
Messages
6
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.
 
Last edited:

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
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.
 
Upvote 0
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
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top