Forum Discussion

macmy034's avatar
macmy034
Resolver I
4 years ago
Solved

Return datetime value based on value in another column

Hey Guys;   I have a column which contains values, minutes past x time, I need to find the smallest value here then return a datetime from another column in the same table.   Eg Person1   84   3...
Need Help
  • Icey's avatar
    Icey
    4 years ago

    Hi macmy034 ,

     

    Is this what you want?

    Calculated StartTime = [Shift Start Time]+#duration(0, 0, 0,[StartCalc])
    Calculated EndTime = [Shift End Time]-#duration(0, 0, 0,[EndCalc])

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HansSu's avatar
HansSu
Frequent Visitor
4 years ago

You can format the result including time. Make a column like:

Result = if (Table[number] = min(Table[number]) , format (Table {Date Time] , "DD/MM/YYYY & " " "HH:MM:SS"))