Adding Hours Column to Date/Time Column

[EC17]

Hi All,

I've a calculated column containing hours (Date type- Decimal Number) and also a date/time column, I want to add the hours to the date/time column but there is many different hours/date values.

My problem is , if the hours column is 12, it's adding 12 days instead of 12 hours, I believe the formatting of my hours column is probably wrong.

I'm relatively new to Power BI so would appreciate any help.

Thank you!

[Greg_Deckler · Accepted solution]

So, date/time is actually a decimal number where the integer portion is the number of days since December 30th, 1899 and the decimal portion is the time component. So, to add hours you will need to add it as the decimal part. So, for example, 1 AM is .0416666667 (1 / 24 ).

[EC17]

Thank you very much, Worked perfectly!