Track time

  • Thread starter Thread starter Jessie
  • Start date Start date
J

Jessie

Hi,

I have a field that tracks the time of call [CallTime] in
the format HHMMSS. I also have a field that contains the
length of the call in seconds [CallDur].

Assuming that time of call is the time that the call is
ended, is there a way I can use the CallDur to find the
Time of the start of call in the format HHMMSS?

If it is easier, I can convert the time with colons
(HH:MM:SS) as well.

Thanks,
Jessie
 
If you want to track a point in time, use a date/time field. You can then
use
DateAdd("s",-CallDur,[CallTime])
to find the start of a call.
 
Back
Top