Times and total time to do a job

[Terrie]

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

 

[Terrie]

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