Hi, I am trying to do some interval summation with 2 different timestamp. However, i am not able to remove the date that is associated with Expression A(only interested in hh:mm).
Expression A: Using a simple formula to add the time stamps together: time([Work Unit Complete Hour] & ':' & [Work Unit Complete Minute], 'hh:mm')
however, when i check further using: date(time([Work Unit Complete Hour] & ':' & [Work Unit Complete Minute ], 'hh:mm'),'m/d/yyyy') i noticed a bunch of dates associated resulting in correct hh:mm but wrong dd/mm/yyyy when i sum this with another field.
I am not trying to hide the display, but really removing the date associated so that i can add this to another expression.
Thank you Sunny, another colleague pointed out to me that i was using 'm/d/yyyy' instead of 'M/D/YYYY' and that made the whole difference when doing the summation. But yes, i thought what you pointed was an error with the data which i couldnt verify