Adding Text Boxes with Times for Total Hours - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Adding Text Boxes with Times for Total Hours

Chris Lopez

7 months ago

I have a text box that, when clicked, shows the date and time an employee started a report and the time when they finished it. I'd like to have a text box that can show the total time between the start and end times?
Im hoping there is a VBA code that I can use to do this.

	Donald Blackwell @Reply 7 months ago
Chris Is Time as a Duration something like what you want? It shows how to calculate the duration between two times

Raymond Spornhauer @Reply

7 months ago

Chris

Also check out the DateDiff Function.

The intervalargument has these settings:

DateDiff (interval, date1, date2)

Interval
yyyy - Year
q - Quarter
m - Month
y - Day of year
d - Day
w - Weekday
ww - Week
h - Hour
n - Minute
s - Second

=============================

Example:

Result in Minutes: DateDiff ("n", TimeStartField, TimeEndField)
Result in Seconds: DateDiff ("s", TimeStartField, TimeEndField)

Hope this helps,

-Raymond

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View