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!

3,49

Status
Not open for further replies.
phpatrick

phpatrick

Programmer
Joined
Jul 9, 2006
Messages
72
Location
BE

I used along time DateDiff to calculate the minites between two timespans.

8:32 till 12.21 : should be 3:49 (tree houres and 49 minutes)
I got 3:81 with my code. Are the minutes here from 0 to 100 ?

Code: 
DateDiff("n";[SHIFT1VAN];[SHIFT1TOT])/60)

If I want totals won't I make the sum of 3:49 and other times ?
 
Sort by date Sort by votes
Hi!

I think you are looking at a decimal, 3.89 hours, since that is the same as 3hrs and 49 minutes.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst
 
Upvote 0 Downvote
yep, txs - 3 houres and 30 minutes is 3.5
 
Upvote 0 Downvote
And what about this ?
Format(SHIFT1TOT-SHIFT1VAN;"h:nn")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top