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

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
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,485
Messages
6,113,931
Members
448,533
Latest member
thietbibeboiwasaco

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