G
Guest
I would like to know how to sum time values and display it in short time
format. Example: I have a tech name joe that visited a particular location
twice in onde day. The first visit was 50 minutes long represented by
(12:50:00 AM or 00:50) the second visit was 40 minutes long represented by
(12:40:00 AM or 00:40) for a total of 90 minutes. I would like to sum these
two durrations and end up with 01:30 (1 hour and 30 mnutes). In my table all
the durations are listed vertically with the techs name to the left of each
entry. I need to group by tech and sum all their time/durations; however,
the sum function does not allow me to do this. PLEASE HELPPPPPPPP!!!
Everything I found told me how to figure the duration from a
starting point to an end point or how to add time to a time
such as #12:50:00 AM# + #12:40:00 AM# which displays 1:30:00 AM or 01:30
Nothing I found told me how to sum two
durations together in an aggregate query. I need to know how to some the
time in a aggregate query so that I can group
by tech.
format. Example: I have a tech name joe that visited a particular location
twice in onde day. The first visit was 50 minutes long represented by
(12:50:00 AM or 00:50) the second visit was 40 minutes long represented by
(12:40:00 AM or 00:40) for a total of 90 minutes. I would like to sum these
two durrations and end up with 01:30 (1 hour and 30 mnutes). In my table all
the durations are listed vertically with the techs name to the left of each
entry. I need to group by tech and sum all their time/durations; however,
the sum function does not allow me to do this. PLEASE HELPPPPPPPP!!!
Everything I found told me how to figure the duration from a
starting point to an end point or how to add time to a time
such as #12:50:00 AM# + #12:40:00 AM# which displays 1:30:00 AM or 01:30
Nothing I found told me how to sum two
durations together in an aggregate query. I need to know how to some the
time in a aggregate query so that I can group
by tech.