TIME - adding and subtracting

[Dublinphil]

Geesh, having a problem again.
I'm trying to add and subtract time entries. The entries correspond to time points on video tapes. The fields are named "TapeLength" entered as 1:00:00(one hour), "TapeBeginning" entered as 0:00:00, and "TapeEnd" entered as 0:24:22 (24 minutes and 22 seconds into the tape) I want to calculate the time remaiming on the tape and put that value into a "TapeRemaining" field. All the fields are formatted as h:nn:ss. I've tried the simple " =[TapeLength]-[TapeEnd], didnt work. I don't know how time and timevalue functions are used. I usually end up getting the "TapeEnd" value in my "TapeRemaining" field. Thanks for your help.

Phil

 

[Frink]

Hallo,

Try
=TimeValue([TapeLength])-TimeValue([TapeEnd])
if the time Remaining field is a time format
or
=format$(TimeValue([TapeLength])-TimeValue([TapeEnd]),"h:mm:ss&quot
if the time Remaining field is a plain text field

- Frink