AnsweredAssumed Answered

timestamp help

Question asked by AustinEckman on Aug 6, 2013
Latest reply on Aug 6, 2013 by philmodjunk


timestamp help


     Im trying to get the total amount of time some one worked a shift and it has a timestampIn and a timestampOut, 



     Current statement is 

     c_TotalWorkedHours  Caclulation  Indexed, = If( TimestampOut = "null" ; " " ; TimestampOut-TimestampIn)



     The null part is needed because it is a tie to all my other code and it sets the total time to " " when it does not have both the time in and time outs. My problem right now is that I will get totals that make no sense at all and are not the correct times. Any tips please comment. Thanks - Austin