View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TBA[_2_] TBA[_2_] is offline
external usenet poster
 
Posts: 58
Default Need help subtracting time values

Excel 2000
Windows 2k Pro

I have a column of time values in a dbf file from a GPS unit. The time
values are in military time format, i.e. "16:34:27" and they are written to
the dbf as string values. I'm having a hard time figuring out how to do
simple subtraction with them. Should I store them as String values or as
Variants? I've tried both with little success. Any help greatly
appreciated. Thanks!

-gk-