Sum Job Time Column

A

Adam

I have a report that provides a total job time in DD:HH:MM:SS format as shown
below that is derived from a DateDiff formula.

Job Time: ([JobTime]\86400) & ":" & Format(([JobTime]\3600) Mod 24,"00") &
":" & Format(([JobTime]\60) Mod 60,"00") & ":" & Format([JobTime] Mod 60,"00")

How do I get my report to sum up the total time worked on a job? I want the
total to be after the last record of each job so you can see a total time for
the entire job for all workers. Currently my report look something like
this...

TempID JobID Name Item Units Produced Job Time
1 2 Joe 123 500 00:00:02:30
2 2 Bob 123 250 00:00:04:40
(Here is where I want
the total)

TempID JobID Name Item Units Produced Job Time
1 4 Jane 456 500 00:00:05:30
2 4 Tim 456 750 00:00:08:40
(Here is where I want
the total)

Any help is much apprciated.
 
K

KARL DEWEY

Try this --
Include field JobTime as an output of your query used to feed the report.
Add a footer to Sorting and Grouping on JobID.
In the footer put a textbox with this --
=(Sum([JobTime])\86400) & ":" & Format((Sum([JobTime])\3600) Mod 24,"00") &
":" & Format((Sum([JobTime])\60) Mod 60,"00") & ":" & Format(Sum([JobTime])
Mod 60,"00")
 
A

Adam

I did this and it says, "Data type mismatch in criteria expression". Any
suggestions?


KARL DEWEY said:
Try this --
Include field JobTime as an output of your query used to feed the report.
Add a footer to Sorting and Grouping on JobID.
In the footer put a textbox with this --
=(Sum([JobTime])\86400) & ":" & Format((Sum([JobTime])\3600) Mod 24,"00") &
":" & Format((Sum([JobTime])\60) Mod 60,"00") & ":" & Format(Sum([JobTime])
Mod 60,"00")

--
KARL DEWEY
Build a little - Test a little


Adam said:
I have a report that provides a total job time in DD:HH:MM:SS format as shown
below that is derived from a DateDiff formula.

Job Time: ([JobTime]\86400) & ":" & Format(([JobTime]\3600) Mod 24,"00") &
":" & Format(([JobTime]\60) Mod 60,"00") & ":" & Format([JobTime] Mod 60,"00")

How do I get my report to sum up the total time worked on a job? I want the
total to be after the last record of each job so you can see a total time for
the entire job for all workers. Currently my report look something like
this...

TempID JobID Name Item Units Produced Job Time
1 2 Joe 123 500 00:00:02:30
2 2 Bob 123 250 00:00:04:40
(Here is where I want
the total)

TempID JobID Name Item Units Produced Job Time
1 4 Jane 456 500 00:00:05:30
2 4 Tim 456 750 00:00:08:40
(Here is where I want
the total)

Any help is much apprciated.
Click to expand...
Click to expand...
 
K

KARL DEWEY

You have to find what it is calling a mismatch.
Try backing up a little. In the footer textbox =Sum([JobTime]) and
run it.

--
KARL DEWEY
Build a little - Test a little


Adam said:
I did this and it says, "Data type mismatch in criteria expression". Any
suggestions?


KARL DEWEY said:
Try this --
Include field JobTime as an output of your query used to feed the report.
Add a footer to Sorting and Grouping on JobID.
In the footer put a textbox with this --
=(Sum([JobTime])\86400) & ":" & Format((Sum([JobTime])\3600) Mod 24,"00") &
":" & Format((Sum([JobTime])\60) Mod 60,"00") & ":" & Format(Sum([JobTime])
Mod 60,"00")

--
KARL DEWEY
Build a little - Test a little


Adam said:
I have a report that provides a total job time in DD:HH:MM:SS format as shown
below that is derived from a DateDiff formula.

Job Time: ([JobTime]\86400) & ":" & Format(([JobTime]\3600) Mod 24,"00") &
":" & Format(([JobTime]\60) Mod 60,"00") & ":" & Format([JobTime] Mod 60,"00")

How do I get my report to sum up the total time worked on a job? I want the
total to be after the last record of each job so you can see a total time for
the entire job for all workers. Currently my report look something like
this...

TempID JobID Name Item Units Produced Job Time
1 2 Joe 123 500 00:00:02:30
2 2 Bob 123 250 00:00:04:40
(Here is where I want
the total)

TempID JobID Name Item Units Produced Job Time
1 4 Jane 456 500 00:00:05:30
2 4 Tim 456 750 00:00:08:40
(Here is where I want
the total)

Any help is much apprciated.
Click to expand...
Click to expand...
Click to expand...
 
A

Adam

I put =sum([Job Time]) in the footer and it still said "Data type mismatch in
criteria expression".

Adam

KARL DEWEY said:
You have to find what it is calling a mismatch.
Try backing up a little. In the footer textbox =Sum([JobTime]) and
run it.

--
KARL DEWEY
Build a little - Test a little


Adam said:
I did this and it says, "Data type mismatch in criteria expression". Any
suggestions?


KARL DEWEY said:
Try this --
Include field JobTime as an output of your query used to feed the report.
Add a footer to Sorting and Grouping on JobID.
In the footer put a textbox with this --
=(Sum([JobTime])\86400) & ":" & Format((Sum([JobTime])\3600) Mod 24,"00") &
":" & Format((Sum([JobTime])\60) Mod 60,"00") & ":" & Format(Sum([JobTime])
Mod 60,"00")

--
KARL DEWEY
Build a little - Test a little


:

I have a report that provides a total job time in DD:HH:MM:SS format as shown
below that is derived from a DateDiff formula.

Job Time: ([JobTime]\86400) & ":" & Format(([JobTime]\3600) Mod 24,"00") &
":" & Format(([JobTime]\60) Mod 60,"00") & ":" & Format([JobTime] Mod 60,"00")

How do I get my report to sum up the total time worked on a job? I want the
total to be after the last record of each job so you can see a total time for
the entire job for all workers. Currently my report look something like
this...

TempID JobID Name Item Units Produced Job Time
1 2 Joe 123 500 00:00:02:30
2 2 Bob 123 250 00:00:04:40
(Here is where I want
the total)

TempID JobID Name Item Units Produced Job Time
1 4 Jane 456 500 00:00:05:30
2 4 Tim 456 750 00:00:08:40
(Here is where I want
the total)

Any help is much apprciated.
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

Apparently [Job Time] is a text field and therefore the error in trying to
sum. You need to bring a number forward to sum.
--
KARL DEWEY
Build a little - Test a little


Adam said:
I put =sum([Job Time]) in the footer and it still said "Data type mismatch in
criteria expression".

Adam

KARL DEWEY said:
You have to find what it is calling a mismatch.
Try backing up a little. In the footer textbox =Sum([JobTime]) and
run it.

--
KARL DEWEY
Build a little - Test a little


Adam said:
I did this and it says, "Data type mismatch in criteria expression". Any
suggestions?


:

Try this --
Include field JobTime as an output of your query used to feed the report.
Add a footer to Sorting and Grouping on JobID.
In the footer put a textbox with this --
=(Sum([JobTime])\86400) & ":" & Format((Sum([JobTime])\3600) Mod 24,"00") &
":" & Format((Sum([JobTime])\60) Mod 60,"00") & ":" & Format(Sum([JobTime])
Mod 60,"00")

--
KARL DEWEY
Build a little - Test a little


:

I have a report that provides a total job time in DD:HH:MM:SS format as shown
below that is derived from a DateDiff formula.

Job Time: ([JobTime]\86400) & ":" & Format(([JobTime]\3600) Mod 24,"00") &
":" & Format(([JobTime]\60) Mod 60,"00") & ":" & Format([JobTime] Mod 60,"00")

How do I get my report to sum up the total time worked on a job? I want the
total to be after the last record of each job so you can see a total time for
the entire job for all workers. Currently my report look something like
this...

TempID JobID Name Item Units Produced Job Time
1 2 Joe 123 500 00:00:02:30
2 2 Bob 123 250 00:00:04:40
(Here is where I want
the total)

TempID JobID Name Item Units Produced Job Time
1 4 Jane 456 500 00:00:05:30
2 4 Tim 456 750 00:00:08:40
(Here is where I want
the total)

Any help is much apprciated.
Click to expand...
Click to expand...
Click to expand...
 
E

Evi

Try
=Sum(Val([JobTime]))

Evi

Adam said:
I put =sum([Job Time]) in the footer and it still said "Data type mismatch in
criteria expression".

Adam

KARL DEWEY said:
You have to find what it is calling a mismatch.
Try backing up a little. In the footer textbox =Sum([JobTime]) and
run it.

--
KARL DEWEY
Build a little - Test a little


Adam said:
I did this and it says, "Data type mismatch in criteria expression". Any
suggestions?


:

Try this --
Include field JobTime as an output of your query used to feed the report.
Add a footer to Sorting and Grouping on JobID.
In the footer put a textbox with this --
=(Sum([JobTime])\86400) & ":" & Format((Sum([JobTime])\3600) Mod 24,"00") &
":" & Format((Sum([JobTime])\60) Mod 60,"00") & ":" & Format(Sum([JobTime])
Mod 60,"00")

--
KARL DEWEY
Build a little - Test a little


:

I have a report that provides a total job time in DD:HH:MM:SS format as shown
below that is derived from a DateDiff formula.

Job Time: ([JobTime]\86400) & ":" & Format(([JobTime]\3600) Mod 24,"00") &
":" & Format(([JobTime]\60) Mod 60,"00") & ":" & Format([JobTime] Mod 60,"00")

How do I get my report to sum up the total time worked on a job? I want the
total to be after the last record of each job so you can see a total time for
the entire job for all workers. Currently my report look something like
this...

TempID JobID Name Item Units Produced Job Time
1 2 Joe 123 500 00:00:02:30
2 2 Bob 123 250 00:00:04:40
(Here is where I want
the total)

TempID JobID Name Item Units Produced Job Time
1 4 Jane 456 500 00:00:05:30
2 4 Tim 456 750 00:00:08:40
(Here is where I want
the total)

Any help is much apprciated.
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentages on time calculations 3
Expression error 7
Help with Totals in a Report 2
Automation error in report 4
sum of "Short Time" Column 17
Sum Time 6
Time duration format 3
DateTime calculation dilemma 2

Top