Time Totals

[fishqqq]

Hi can someone tell me how to set the value of a field to calculate
the total time taken to do a job.

ie.
[start] = 5/4/2009 7:08:20 PM
[finish] = 5/4/2009 7:10:20 PM
[total] = should equal 0:02:00 (ie 2 min)

the idea is to be able to add up all the time spent on a job for
billing purposes

Is there an easy way to calculate the total time?
Thanks

 

[ruralguy via AccessMonster.com]

This link should help: http://www.mvps.org/access/datetime/date0004.htm

Hi can someone tell me how to set the value of a field to calculate
the total time taken to do a job.

ie.
[start] = 5/4/2009 7:08:20 PM
[finish] = 5/4/2009 7:10:20 PM
[total] = should equal 0:02:00 (ie 2 min)

the idea is to be able to add up all the time spent on a job for
billing purposes

Is there an easy way to calculate the total time?
Thanks

 

[fishqqq]

This link should help:http://www.mvps.org/access/datetime/date0004.htm

Hi can someone tell me how to set the value of a field to calculate
the total time taken to do a job.

ie.
[start] = 5/4/2009 7:08:20 PM
[finish] = 5/4/2009 7:10:20 PM
[total] = should equal 0:02:00 (ie 2 min)

the idea is to be able to add up all the time spent on a job for
billing purposes

Is there an easy way to calculate the total time?
Thanks

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200905/1

that works perfectly. tks!

 

[ruralguy via AccessMonster.com]

Great! Glad I could help.

This link should help:http://www.mvps.org/access/datetime/date0004.htm

[quoted text clipped - 18 lines]

http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200905/1

that works perfectly. tks!