Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Duration between two times

Hello all, I have the following data: 10/01/2019 23:51 01:20 30/02/2019 13:12 16:05 05/01/2019 22:40 03:20 08/02/2019 17:31 20:40 First column is data event, second is start ...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous 

    First of all, make sure the two columns are timestamp columns

    Else use time function and make them time stamp

     

    Start Time = Time(left([Strat],2),right([Strat],2)) // Do same with end

     

    My suggestion would make them datetime with date , You can leave  the date part if needed

    New columns

    Start date time = [Date]+[Start Time]

    end Date time = if([Start Time] <[End Time ],[Date]+[EndTime],([Date]+[EndTime])+1)

     

    Now you can use date diff

    Diff = datediff([Start date time],[end Date time].day)

     

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous 

First of all, make sure the two columns are timestamp columns

Else use time function and make them time stamp

 

Start Time = Time(left([Strat],2),right([Strat],2)) // Do same with end

 

My suggestion would make them datetime with date , You can leave  the date part if needed

New columns

Start date time = [Date]+[Start Time]

end Date time = if([Start Time] <[End Time ],[Date]+[EndTime],([Date]+[EndTime])+1)

 

Now you can use date diff

Diff = datediff([Start date time],[end Date time].day)