Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculating Time Difference with Time Only Fields

Status
Not open for further replies.
maengler2000

maengler2000

Technical User
Joined
Feb 2, 2012
Messages
7
Location
US
I need to calculate the time difference between two fields that are time only. Using the DateDiff returns an error that they must be date/time fields.
 
Sort by date Sort by votes
It is not necessary to use DateDiff. Subtract 1 time from the other and the result is the number of seconds between the 2 times.

Cheers
Pete
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

POrlowski
  • Locked
  • Question Question
Calculating Sick Time
Replies
7
Views
889
POrlowski
POrlowski
B
  • Locked
  • Question Question
Difference of a field between 2 variable dates
Replies
1
Views
625
hilfy
hilfy
Cpreston
  • Locked
  • Question Question
Only Select certain rows
Replies
7
Views
1K
Cpreston
Cpreston
D
  • Locked
  • Question Question
Running total from a subreport only showing last value
Replies
4
Views
1K
doodledump
D
Corinne30
  • Locked
  • Question Question
Division of currency formula with/without rounding
Replies
7
Views
2K
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top