time tracking reports

[Guest]

I have a form I have created to track employees Log In Time. There are two
command buttons that log the BeginTime and EndTime. On my report I have but
an unbound text box and used the control source as =[endtime]-[begintime].
Now it displays each record as (example 8:32) it so far on the detail line
works. However I am needing a way to show how many hours 20 plus people have
worked. Can anyone help me with a basic design that might work best. I have
been using short time.

Thanks Jen

 

[Allen Browne]

See:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

The article explains how to calculate the time in minutes, and display the
result in hours and minutes.

 

[Allen Browne]

You have created a query with a calculated field named Minutes as the
article suggests?

Then in the report, you have a text box name Hours that has Control Source
of:
=[Minutes] \ 60 & Format([Minutes] Mod 60, "\:00")

You cannot sum this directly, because a) it is not in the report's query,
and b) it is a piece of text and not a numeric value.

In the Report Footer section where you want to display the total, use this
Control Source:
=Sum([Minutes]) \ 60 & Format(Sum([Minutes]) Mod 60, "\:00")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

The page was great help and I figured the per line. Now it says not for
sum.
Do you have a sum equation. I am breaking time out per detail and when I
do
Sum[Hours] it wants me to put a parameter. I want to be able to calculate
Sum per detail then per all employees.

Thanks in advance
Jen

See:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

The article explains how to calculate the time in minutes, and display
the
result in hours and minutes.

I have a form I have created to track employees Log In Time. There are
two
command buttons that log the BeginTime and EndTime. On my report I have
but
an unbound text box and used the control source as
=[endtime]-[begintime].
Now it displays each record as (example 8:32) it so far on the detail
line
works. However I am needing a way to show how many hours 20 plus
people
have
worked. Can anyone help me with a basic design that might work best.
I
have
been using short time.

Thanks Jen

 

[Ian Davies]

Try =sum([endtime]-[begintime])