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!

TIME DIFFERENCE

Status
Not open for further replies.
woolade

woolade

Technical User
Joined
Nov 8, 2001
Messages
51
Location
AU
Is there a formula to use that allows you to calculate the difference in minutes between the time in a Date Time field and midnight of that same date?

Thanks

woolade
 
Sort by date Sort by votes
Try:

datediff("n", cdatetime(year({table.datefield}),month({table.datefield}),day({table.datefield}),0,0,0),{table.datefield})

Note that midnight of the same day is 12:00AM, which means that it's earlier.

-k
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

B
  • Locked
  • Question Question
Difference of a field between 2 variable dates
Replies
1
Views
616
hilfy
hilfy
POrlowski
  • Locked
  • Question Question
Calculating Sick Time
Replies
7
Views
881
POrlowski
POrlowski
nerdygirlgear
  • Locked
  • Question Question
Limit sub report records to a time range on main report
Replies
1
Views
356
hilfy
hilfy
GCL2007
  • Locked
  • Question Question
Date fields coming into Crystal as Date/Time
Replies
2
Views
494
GCL2007
GCL2007
Fermo Zolli
  • Locked
  • Question Question
Difference in hours for badging date and time activity
Replies
13
Views
749
Fermo Zolli
Fermo Zolli

Part and Inventory Search

Sponsor

Back
Top