Results 1 to 3 of 3

Thread: Add time since 1900
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2012
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Add time since 1900

    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 by belebala; Aug 2nd, 2019 at 03:10 PM.

  2. #2
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,186
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Add time since 1900

    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.
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

  3. #3
    New Member
    Join Date
    Apr 2012
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Add time since 1900

    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 by belebala; Aug 6th, 2019 at 05:08 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •