running sum for working hour and minute

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

I have a report for working hour and minute and would like have a
running sum for the report like following:


Employee (Working hour) (Working Minute) (Working hour Required)
(hour run sum) (minute run sum)
Employee1 40
10 35
5 10
Employee1 26
30 35
-4 20
Employee1 37
0 35
-2 20


I tried running sum property in the text box, it works only for one
number.
Since hour and minute acccumualte need consider borrwo and carry for
hour, are there any better solution for this?


Your help is great appreciated,
 
please do not ask the same question in 2 different newsgroups. this
question has been asked here:

microsoft.public.access.reports

thank you

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*
 
Since hours and minutes are really a measure of the same thing --
passing time -- why not have a running sum like this:

=[hour_fieldname] + [minute_fieldname]/60


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*
 
Strive4peace's method provude cumulative time in fractional hours. If you
would prefer to see HH:MM, set the running sum field to:

=TimeSerial([hour_fieldname], [minute_fieldname])
and set its format to "hh:nn" (yes, nn, not mm!)
That does proper mod-60 addition.
 
good solution, Ted ;) I didn't test it but it looks like it should work

iccsi -- adding on to what Ted said: when 'm' is used in a format code,
it represents Month; 'n' represents miNute

Warm Regards,
Crystal

*
(: have an awesome day :)
*
 
Back
Top