Forum Discussion

android1's avatar
android1
Post Patron
10 years ago

Time difference between dates containing day year and time

Hi,

 

How do you calculate the difference between dates and time that are month name, month number year and time. I have two columns and I need to calculate the difference in minutes between the two. 

Need Help

2 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    10 years ago

    Are these columns in  Date/Time format?  If so, just subtract the latest date from the earliest date, then format this new column as a decimal number. It will give you a decimal day. Eg 0.5 = 12 hours.  You can then convert this to what ever you need 

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    10 years ago

    Hi Android1,

     

    DATEDIFF function can help your get the expected column easily.

     

    Regards,

    Charlie Liao