Adding timestamp (days/hours/minutes) fields

  • Thread starter Thread starter jsg
  • Start date Start date
J

jsg

Does anyone know how to add values together for a field that includes the
day, hours and minutes? We have a field in our database (time_spent) which
records how long it took to complete a task (ie: how many days, hours and/or
minutes). We are needing to add these times together to figure out the
overall time spent working on all items. Any help is much appreciated.

Thanks,
Jenni
 
What is the data type of the field?
What are you comparing it to to do the calculations?

If you have StartTime and EndTime fields in your table, then you should not
be storing the time spent value at all. You should calculate it when you
want to present it to the users.

Post back with some detail, and we can offer some suggestions.
 
Back
Top