How to Add Minutes Column to Dates Column

[Shakeerm]

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

[v-diye-msft]

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!

[Ashish_Mathur]

Hi,

Write this calculated column formula

Actual Started + Allocated Time

[Shakeerm]

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

[Ashish_Mathur · Accepted solution]

Hi,

See this

[ryan_mayu]

@Shakeerm 

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

[ryan_mayu]

@Shakeerm,

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

[Shakeerm]

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.