Times and total time to do a job

[Guest]

I want a field where the customer can enter the time it took him to do a
specific job ie 1 hour 40 minutes. If he has returned to the job a few times
and added another 30 mins then another 2 hours, the total time taken for that
job will be 4 hours 10 mins. I am trying to use the hh:mm format but this is
actual time AM or PM. Any way I can do this? (preferably not in VB)
Thanks in advance

 

[Steve Schapel]

Terrie,

Best to have 2 fields, for HoursWorked and MinutesWorked. You can place
controls on your form in such a way that it looks good . And then,
for your job totals, it is just a simple expression, somethig like this...
=Sum([HoursWorked])+Sum([MinutesWorked])\60 & ":" &
Sum([MinutesWorked]) Mod 60

 

[Guest]

Thanks Steve, I got as far as 2 fields as you suggest but I must say your
expression is an awful lot better than mine I will use it, thanks

Terrie,

Best to have 2 fields, for HoursWorked and MinutesWorked. You can place
controls on your form in such a way that it looks good . And then,
for your job totals, it is just a simple expression, somethig like this...
=Sum([HoursWorked])+Sum([MinutesWorked])\60 & ":" &
Sum([MinutesWorked]) Mod 60

--
Steve Schapel, Microsoft Access MVP

I want a field where the customer can enter the time it took him to do a
specific job ie 1 hour 40 minutes. If he has returned to the job a few times
and added another 30 mins then another 2 hours, the total time taken for that
job will be 4 hours 10 mins. I am trying to use the hh:mm format but this is
actual time AM or PM. Any way I can do this? (preferably not in VB)
Thanks in advance

 

[Joseph Meehan]

I want a field where the customer can enter the time it took him to do
a specific job ie 1 hour 40 minutes. If he has returned to the job a
few times and added another 30 mins then another 2 hours, the total
time taken for that job will be 4 hours 10 mins. I am trying to use
the hh:mm format but this is actual time AM or PM. Any way I can do
this? (preferably not in VB)
Thanks in advance

May I suggest that it might be a good idea to use two tables. Table1
would identify the job and who was doing the work. Table2 would list each
time increment (you might also want the date of the work as well). That way
you could compute the total time whenever you wanted. Trying to maintain a
running total is likely to have a greater opportunity for errors IMO. It
also would provide less information.

As indicated you might want two fields for each record, hours and
minutes. I think I might actually store the time as hours and parts of
hours. That is force the user to use a form and collect the data as hours
and minutes, then divide the minutes by 60 to get the decimal part. Add the
hours and decimal part of the hours together to store the data. You could
recompute the minutes for display later if you like.