Thread: TIME values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Gordon Kevin Gordon is offline
external usenet poster
 
Posts: 1
Default TIME values

Hi

I am currently dealing with an Access database that tracks
activity management data for my staff. The system outputs
the results of a query to Excel that details the first
record entered onto the system, and the last record
entered as time values with format "HH:MM:SS" - I then
subtract the lowest value (TimeL) from the highest (TimeH)
to give me an indication of the time users spent at work
(TimeDiff).

However, when I try to add the TimeDiff values together to
give a total number of hours, I get an odd value - all I'm
looking to do is total the number of hours together. Is
there an easy way to do this?

TIA