Forum Discussion

Shakeerm's avatar
Shakeerm
Icon for Helper II rankHelper 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

 

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

 

Need Help

7 Replies

    • Shakeerm's avatar
      Shakeerm
      Icon for Helper II rankHelper II
      6 years ago

      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. 

    • Shakeerm's avatar
      Shakeerm
      Icon for Helper II rankHelper 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
        Icon for Super User rankSuper User
        6 years ago

        Shakeerm 

         

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

         

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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!