cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

How to Add Minutes Column to Dates Column

Hi

i have a date column with Date & Time & a minute column which is a difference between two time columns. However i would like to add this Minutes to the Date Column and the end result should be

 

if Date is 6/3/2020 1:30:00

And the Allocated Minutes are 0:03 Minutes

Then, 6/3/2020 1:33:00

 

Any help to achieve this would be appreciated

 

DateAddtoMinutes.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: How to Add Minutes Column to Dates Column

Hi,

See this

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

7 REPLIES 7
Highlighted
Memorable Member
Memorable Member

Re: How to Add Minutes Column to Dates Column

@Shakeerm,

 

You can try change the data type. Does this meet your request?

 

 

1.PNG

Did I answer your question? Mark my post as a solution.Appreciate your Kudos!
Proud a to be a Datanaut!
Thanks and BR
Ryan
Highlighted
Helper II
Helper II

Re: How to Add Minutes Column to Dates Column

Hey Ryan

Thanks for reaching out. However that does not solve my problem. I need the date & time both to be visible and also simply Adding the two columns does not add the minutes to the existing date/TIme. 

Highlighted
Super User IV
Super User IV

Re: How to Add Minutes Column to Dates Column

Hi,

Write this calculated column formula

Actual Started + Allocated Time


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted
Helper II
Helper II

Re: How to Add Minutes Column to Dates Column

Hi Ashish

I'm not getting the expected result from the Solution you provided. It adds an additional date instead of adding Minutes. 

What i need is the following

 

Actual Started Date = 1/4/2020 4:40:00

Allocated Time (in Mins) = 00:03:00

 

Then, the result should be = 1/4/2020 4:43:00

 

 

Highlighted
Memorable Member
Memorable Member

Re: How to Add Minutes Column to Dates Column

@Shakeerm 

 

You only need to add the mintute column to datetime column. Is this what you want?

 

1.PNG

Did I answer your question? Mark my post as a solution.Appreciate your Kudos!
Proud a to be a Datanaut!
Thanks and BR
Ryan
Highlighted
Super User IV
Super User IV

Re: How to Add Minutes Column to Dates Column

Hi,

See this

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Highlighted
Community Support
Community Support

Re: How to Add Minutes Column to Dates Column

Hi @Shakeerm 

 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors