Adding timestamp (days/hours/minutes) fields

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
 
K

Klatuu

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADDING HOURS AND MINUTES 2
Sum Times 3
Formula to convert Hours to Days, Hours Minutes 1
Adding Total Hours for the Week 4
Adding hours and minutes 7
add time to a field - MINUTES 3
converting Days Hours & minutes into just minutes in excel 5
workday, networkday or something else? 5

Top