Forum Discussion

GilesWalker's avatar
GilesWalker
Icon for Skilled Sharer rankSkilled Sharer
10 years ago
Solved

How to calculate the time difference

Hi everyone,   This one has been driving me crazy for a couple days and I am sure I am just over thinking it. Hope someone can assist with this issue:   I have a few thousand rows of data which c...
Need Help
  • samdthompson's avatar
    samdthompson
    10 years ago

    Here you go:

     

    docket load time = (calculate(MAX(Table1[Date Loaded]),allexcept(Table1,Table1[Consignment]))-calculate(min(Table1[Date Loaded]),allexcept(Table1,Table1[Consignment])))*3600

GilesWalker's avatar
GilesWalker
Icon for Skilled Sharer rankSkilled Sharer
10 years ago

samdthompson - thank you for helping with this. I had tried using the all except on consignments but hadnt done the min and max on the date. Thanks for your help with this.

 

Giles

samdthompson's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
10 years ago

No worries mate, its just one of those fresh eyes things.