Add original hour column to accompany date column without datetime.

L

LambChoptheKid

New Member
Joined
Dec 10, 2022
Messages
35
Office Version
  1. 365
Platform
  1. Windows
Hey everyone,

I am trying to add a new 24-hour time column to a one column table that contains only dates. The Date column is dynamically pulled from a database that provides dates for 30 days into the future.

I am doing projection work, so there is no original time column for me to pull from.

My goal is to have a total of 2 columns (Date, Time) and 744 rows (31*24).

I have attached a picture of the table that I am working with.

I am relatively new to Power Query so my understanding of M language is still limited.

Any help is greatly appreciated!
 

Attachments

  • Column.png
    Column.png
    30.8 KB · Views: 13

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
You are basically trying to do a crossjoin.
Create a second table with the 24 hours in a column and call it time
Go back to the date column, add column, custom column, and type =time
Then expand the new column to generate the table you need.
 
Upvote 1
Solution
You must log in or register to reply here.

Similar threads

L
  • Question
Error with making hour column from datetime column
Replies
0
Views
198
LambChoptheKid
L
D
  • Question
Power Query refresh taking HOURS after adding custom column
Replies
3
Views
546
Matt Allington
M
C
  • Question
Query filtering using Today() as a date ?
Replies
8
Views
290
alansidman
A
W
  • Question
In Power Query based on contract dates assign number of days per month
Replies
2
Views
279
Wishmaster40
W
T
  • Question
Aggregation tables do not include real-time data
Replies
0
Views
165
TamirBasin
T

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

Share this page

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