timestamp difference calculated
need to find calculated difference between two timestamps - would mean two timestamp fields has date and time but can only calculate the times and ignore the date.
But why ignore the date? (Maybe I am misunderstanding what you mean by "ignore".)
Timestampfield2 - timestampfield1
will compute the elapsed time in seconds, but the date will not be ignored. This can be very useful when Timestampfield1 records a date and time just before midnight and Timestampfield2 reocrds a time after midnight.
GetasTime ( Timstampfield2 ) - Getastime ( Timestampfield1 )
will ignore the date, but if that's what you want, it would be simpler to use two time fields instead of timestamp fields.
Yeah I thing your right.
I want to trigger a timestamp with a script button ...then hours or days later trigger another timestamp with another script button ... then calculate the actual time difference betweeen those two timestamps.
I thought it would have to ignore the date to get actual hours of elapsed time difference, but if the date can be includeded thats good.
Yep just subtract, but keep in mind the result will be in seconds. You can select Time as a return type if you want to see the result as HH:MM::SS or you can select Number as the return type just to get the total seconds (or Hours if you divide by 3600).
Thank you for that.
I got in days by divide by /60/60/24 and do a round()
Retrieving data ...