Adding hours

  • Thread starter Thread starter Daniel Neto
  • Start date Start date
D

Daniel Neto

In Excel one formates a cell with [h]:mm:ss to have the
addition of the total hours in a column even when it
exceeds 24 hours, for example the total 172:56:32. This
format does not work in the format of a sum in Access
reports. Can someone tell me how to display the sum of
the total hours like in Excel? Thanks.
 
Maybe I'm not understanding exactly what you need, but the format for hours,
minutes & sec is slightly different in Access. For minutes it's n not m.
hth
Connie
 
Your basic issue is that you may be storing durations of time in a field
meant for storing a point in time. For instance, if you asked me how many
hours I was at work today, I would not say 8 o'clock. I would say 8 Hours.

Consider storing your durations in single or double precision numeric fields
as the number of hours or minutes or whatever. Then you can easily some
these to get the proper answer.
 
I know exactly what you mean because I have been
struggling with the same problem. Here is what I have used
with limited success.
for each row/record I had a column called Wasted time and
the formula there is [StartTime]-[ReadyTime] and for the
column total I used =Sum([StartTime]-[readyTime]). The
records were grouped. The problem I had with this formula
is when one of the group totals went over 86 rows the
total would be erractic. Haven't been able to get an
answer to that.
 
Back
Top