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 SkipVought 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
Jul 9, 2006
72
0
0
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
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