Forum Discussion

turbea's avatar
turbea
New Member
9 years ago
Solved

Calculating date/time difference

          Hello,   I would like to calculate the difference between 2 date/time value (one is an additional column, the other is a measure). I need to see the result in days, but in deci...
Need Help
  • Back2Basics's avatar
    Back2Basics
    9 years ago

    Try this

     

     

    New column = (AIRActionHistory[ScanImportDate]-AIRActionHistory[FirstActionDate])+(((HOUR(AIRActionHistory[ScanImportDate])-hour(AIRActionHistory[FirstActionDate]))+(((MINUTE(AIRActionHistory[ScanImportDate])-MINUTE(AIRActionHistory[FirstActionDate]))/60))/24)

     

    I dont think you need the extra .[Date] at the end of things

turbea's avatar
turbea
New Member
9 years ago

Unfortunately I got 6.78 as result instead of 6.44.

turbea's avatar
turbea
New Member
9 years ago

With the second option I can see the decimals, but they are 00 only. It seems the formula cannot use the time in the date/time format to calculate. Only takes the date.