Forum Discussion

Shakeerm's avatar
Shakeerm
Helper II
6 years ago
Solved

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  ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    See this

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Write this calculated column formula

Actual Started + Allocated Time

Shakeerm's avatar
Shakeerm
Helper II
6 years ago

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

 

 

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    6 years ago

    Shakeerm 

     

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

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Hi,

    See this