Forum Discussion

mohamedm's avatar
mohamedm
Frequent Visitor
4 years ago
Solved

Calculate Date and time from Different Column

Hi There, Is it possible to calculate date and time from different columns? I'd like to calculate the difference in date and time between these two columns; please assist.    
Show and Tell
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Use below formula

    = ([Inbound Date]&[Inbound Time])-([Out Date]&[Out Time])

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Use below formula

= ([Inbound Date]&[Inbound Time])-([Out Date]&[Out Time])