Hey guys! I have created an Access 2010 database. On one of the tables, there are fields [Start Time], [End Time] and [Total Time]. The user will input the start and end times but and the total time will be the difference between the two. I cannot figure out how to go about this. Any help or direction would be greatly appreciated!!

6 Years
Discussion Span
Last Post by jtodd

Thanks for you input Chris! I have tried to implement the DateDiff function but have ran into a snag. Below is how I am using it in a query.

Total Time: DateDiff("Short Time",[Work Start Time],[Work End Time])

It is returning "#Func!". Do you have any idea what could be causing this?


datediff returns a number, ie number of days, number of hours, number seconds depending on the first parameter. so if you want the number of hours between the two the call looks like

noHours = datediff("h",[Work Start Time],[Work End Time])

or in SQL

noHours:datediff("h",[Work Start Time],[Work End Time])

Edited by ChrisPadgham: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.