Dnl stamp could be a calculated field with timestamp result. Try:
Timestamp (service date ; driver in )
That mostly works but I still get the same wierd seconds issue so all my times are off by 24 seconds. I know this has something to do with subtracting the driver in time by 24 hours. It seems like I should subtract by seconds but that doesn't work.
To subtract 24 hours from a time field, you'll need to subtract 24*3600
Try to use a formula like:
Timestamp ( service date ;
driver in > 3600 * 24 ; driver in - 3600 * 24;
If I do this as a straight time, I get a negative time number.
If I do this as a timestamp, I get a super big negative number (when doing this from a scriptl) OR the wrong date (when doing this from a calc field). Example: timestamp (service date; driver in - 864000) with the driver in time being 2620 and date 5/23/12, the calculation comes out as 5/14/15 with time 2:20AM
"with the driver in time being 2620"
Was it a typo ? Are you meaning 26:20 ?
Also: 24*3600 = 86400, not 864000
thanks... nothing like a zero to mess everything up!