Summing Times

[Guest]

I think i have the math right, but i am stuck now. I have a query which
calculates the elapsed time that a student puts in a given activity on a
given day. I have:

total time:=[End Time] - [Start Time]

Now I want to sum the totals in a report grouping footer. When i use
:=Sum([Total]) I get an error message that says i must define a Sort Field
or Expression in the form i am trying to preview.

Please help

 

[Rick Brandt]

I think i have the math right, but i am stuck now. I have a query
which calculates the elapsed time that a student puts in a given
activity on a given day. I have:

total time:=[End Time] - [Start Time]

Now I want to sum the totals in a report grouping footer. When i use
:=Sum([Total]) I get an error message that says i must define a Sort
Field or Expression in the form i am trying to preview.

Please help

=Sum([End Time] - [Start Time])

You sum "fields" not "controls".

 

[Guest]

Yeah it was an unrelated error. I fixed the Sort Eror Message, but I still
have a problem Summing times. I have my times totaled, but I cannot get sum
to be formatted in hours and minutes.

I think i have the math right, but i am stuck now. I have a query
which calculates the elapsed time that a student puts in a given
activity on a given day. I have:

total time:=[End Time] - [Start Time]

Now I want to sum the totals in a report grouping footer. When i use
:=Sum([Total]) I get an error message that says i must define a Sort
Field or Expression in the form i am trying to preview.

Please help

=Sum([End Time] - [Start Time])

You sum "fields" not "controls".

 

[Duane Hookom]

Consider summing the minutes like:
=Sum(DateDiff("n", [Start Time], [End Time]) )
If you want hours, divide the summed minutes by 60.
--
Duane Hookom
MS Access MVP

Yeah it was an unrelated error. I fixed the Sort Eror Message, but I
still
have a problem Summing times. I have my times totaled, but I cannot get
sum
to be formatted in hours and minutes.

I think i have the math right, but i am stuck now. I have a query
which calculates the elapsed time that a student puts in a given
activity on a given day. I have:

total time:=[End Time] - [Start Time]

Now I want to sum the totals in a report grouping footer. When i use
:=Sum([Total]) I get an error message that says i must define a Sort
Field or Expression in the form i am trying to preview.

Please help

=Sum([End Time] - [Start Time])

You sum "fields" not "controls".

 

[John Spencer]

To expand a bit on Mr. Hookom's response to give you a display of hours and minutes

=Sum(DateDiff("n", [Start Time], [End Time]))\60 & ":" &
Format(Sum(DateDiff("n", [Start Time], [End Time])) Mod 60,"00")

Consider summing the minutes like:
=Sum(DateDiff("n", [Start Time], [End Time]) )
If you want hours, divide the summed minutes by 60.
--
Duane Hookom
MS Access MVP

Yeah it was an unrelated error. I fixed the Sort Eror Message, but I
still
have a problem Summing times. I have my times totaled, but I cannot get
sum
to be formatted in hours and minutes.

Dan Robles wrote:
I think i have the math right, but i am stuck now. I have a query
which calculates the elapsed time that a student puts in a given
activity on a given day. I have:

total time:=[End Time] - [Start Time]

Now I want to sum the totals in a report grouping footer. When i use
:=Sum([Total]) I get an error message that says i must define a Sort
Field or Expression in the form i am trying to preview.

Please help

=Sum([End Time] - [Start Time])

You sum "fields" not "controls".

 

[Guest]

Thanks Gents. a quick follow up though, will this allow mw to sum past 24
hours?
I need a running total over a school year.

Dan

To expand a bit on Mr. Hookom's response to give you a display of hours and minutes

=Sum(DateDiff("n", [Start Time], [End Time]))\60 & ":" &
Format(Sum(DateDiff("n", [Start Time], [End Time])) Mod 60,"00")

Consider summing the minutes like:
=Sum(DateDiff("n", [Start Time], [End Time]) )
If you want hours, divide the summed minutes by 60.
--
Duane Hookom
MS Access MVP

Yeah it was an unrelated error. I fixed the Sort Eror Message, but I
still
have a problem Summing times. I have my times totaled, but I cannot get
sum
to be formatted in hours and minutes.

:

Dan Robles wrote:
I think i have the math right, but i am stuck now. I have a query
which calculates the elapsed time that a student puts in a given
activity on a given day. I have:

total time:=[End Time] - [Start Time]

Now I want to sum the totals in a report grouping footer. When i use
:=Sum([Total]) I get an error message that says i must define a Sort
Field or Expression in the form i am trying to preview.

Please help

=Sum([End Time] - [Start Time])

You sum "fields" not "controls".

 

[Duane Hookom]

Did you try it?

--
Duane Hookom
MS Access MVP

Thanks Gents. a quick follow up though, will this allow mw to sum past 24
hours?
I need a running total over a school year.

Dan

To expand a bit on Mr. Hookom's response to give you a display of hours
and minutes

=Sum(DateDiff("n", [Start Time], [End Time]))\60 & ":" &
Format(Sum(DateDiff("n", [Start Time], [End Time])) Mod 60,"00")

Consider summing the minutes like:
=Sum(DateDiff("n", [Start Time], [End Time]) )
If you want hours, divide the summed minutes by 60.
--
Duane Hookom
MS Access MVP

Yeah it was an unrelated error. I fixed the Sort Eror Message, but I
still
have a problem Summing times. I have my times totaled, but I cannot
get
sum
to be formatted in hours and minutes.

:

Dan Robles wrote:
I think i have the math right, but i am stuck now. I have a query
which calculates the elapsed time that a student puts in a given
activity on a given day. I have:

total time:=[End Time] - [Start Time]

Now I want to sum the totals in a report grouping footer. When i
use
:=Sum([Total]) I get an error message that says i must define a
Sort
Field or Expression in the form i am trying to preview.

Please help

=Sum([End Time] - [Start Time])

You sum "fields" not "controls".