3,49

[phpatrick]

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 ?

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

If I want totals won't I make the sum of 3:49 and other times ?

 

[jebry]

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

 

[phpatrick]

yep, txs - 3 houres and 30 minutes is 3.5

 

[PHV]

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