XProfan

GDL

Hi,
integrally roughly outlined.

Maschinenstartzeit and anschließender Maschinenauszeit erfassen.Maschinenauszeit - Maschinenstartzeit is Maschinenlaufzeit.

any times in sec.

Hello
Georg

Windows7 Xprofan 8,9,10 [...]

[...]

09/07/08 ▲

Gerhard
Praher

Hello Sato,

means I come Yes on 308 minutes and not 405, The on your Screenshot To see are.

so How I this see goes it to you around the Gesamtlaufzeit the machine.
thereby is not absolutely relevant How long which worker so worked has.
that is means, that You The reinen terms detect must - and of course in the form:

any Zeitangaben converting on minutes !

(spätestes end the Laufzeit - [less] frühester Beginn the Laufzeit)

Ermittle The Stillstandszeiten ditto in the Nature and point and ziehe tappt im dunkeln from the Gesamtlaufzeit ex.
so sustain You The tatsächliche Laufzeit.
The Number of minutes, The eachone colleagues on the machines worked has, is for Maschinenzeitberechnung a Base,
there of since the terms stammen.
How long one colleagues hereon worked has is solely (possible) for Lohnermittlung, in each drop but for
Nachkalkulation important. possible too for Preisfindung, if it itself circa a Lohnarbeit deals, The to tatsächlichem
hoisted verrechenbar is.

I hope, the helps you a little bit.

Greeting Gerhard

Windows XP Pro, SP3
Jetzt: XProfan 11
Was ich liebe sind 3 "F": meine Familie, meine Firma, meine Freizeit.

09/07/08 ▲

Sato
Pinto

Hello Gerhard

thanks for your trouble
have right is Yes 308 at Screenshot are no realle data have it only simply in Excel written.
I faith the Problemm becomes a little bit tougher his whom it could z.b so ausehen if I The data from the different Technikern einlese

Dieter ; ; MaschineA ; ; 07-09-2008 ; ; 09:12 ; ; 07-09-2008 ; ; 10:31
Dieter ; ; MaschineA ; ; 07-09-2008 ; ; 10:41 ; ; 07-09-2008 ; ; 11:01
Dieter ; ; MaschineA ; ; 07-09-2008 ; ; 11:21 ; ; 07-09-2008 ; ; 12:31
Peter ; ; MaschineA ; ; 07-09-2008 ; ; 08:32 ; ; 07-09-2008 ; ; 10:47
Peter ; ; MaschineA ; ; 07-09-2008 ; ; 11:12 ; ; 07-09-2008 ; ; 11:51
Peter ; ; MaschineA ; ; 07-09-2008 ; ; 12:12 ; ; 07-09-2008 ; ; 12:22

to whom sort by Anfangszeit could the in the List view so ausehen
Peter ; ; MaschineA ; ; 07-09-2008 ; ; 08:32 ; ; 07-09-2008 ; ; 10:47
Dieter ; ; MaschineA ; ; 07-09-2008 ; ; 09:12 ; ; 07-09-2008 ; ; 10:31
Dieter ; ; MaschineA ; ; 07-09-2008 ; ; 10:41 ; ; 07-09-2008 ; ; 11:01
Peter ; ; MaschineA ; ; 07-09-2008 ; ; 11:12 ; ; 07-09-2008 ; ; 11:51
Dieter ; ; MaschineA ; ; 07-09-2008 ; ; 11:21 ; ; 07-09-2008 ; ; 12:31
Peter ; ; MaschineA ; ; 07-09-2008 ; ; 12:12 ; ; 07-09-2008 ; ; 12:22

in the Momment knows I not yet The Vorgehendsweise as on the simplest To to charge is

greeting
Sato

Sato Pinto
WIN XP Home
XPROFAN 11

Gerhard
Praher

Hello Sato,

I refer me in the subesquent directly on your example.
The Sorting to Anfangszeit is necessary, the have you got Yes already made.
moreover goes it with Vergleichsoperationen.

first Beginn and erstes end (Peter machine A 8:32 - 10:47) - in minutes: 512 - 647

Stillstandszeit = 0
Beginn = 512
end = 647

comparison with 2. row (Dieter machine A 9:12 - 10:31) - in minutes: 552 - 631
these within [Beginn] and [€nde] - so [Stillstandszeit] furthermore 0

3. row (Dieter machine A 10:41 - 11:01) - in minutes: 641 - 661
The Beginnzeit is larger as [Beginn] and small as [end] - The Endezeit is larger as [end]
it deals itself means circa a durchgehende working hours - [Stillstandszeit] remaining therefore 0
[end] = 661

4. row (Peter machine A 11:12 - 11:51) - in minutes: 672 - 711
672 is larger as [Beginn] and larger as [end]
[Stillstandszeit] is accordingly The difference between 672 and [Beginn]; 672 - 661 = 11
711 is now The supreme Endezeit - means [end] = 711

5. row (Dieter machine A 11:21 - 12:31) - in minutes: 681 - 751
here's The Beginnzeit small as [end] and the Endezeit larger as [end].
so is it a durchgehende working hours. [Stillstandszeit] remaining on the worth of 11
[end] = 751

6. row (Peter machine A 12:12 - 12:22) - in minutes: 732 - 742
both times lying within [Beginn] and [end]
so remaining The [Stillstandszeit] with 11; [end] remaining ditto on 751

Endresultat: Stillstandszeit = 11 minutes
Maschinenzeit is accordingly: [end] - [Beginn] - [Stillstandszeit]; means: 751 - 512 - 11 = 228 = 3 hours and 48 minutes

I hope, that You so what begin can.

love Regards
Gerhard

Windows XP Pro, SP3
Jetzt: XProfan 11
Was ich liebe sind 3 "F": meine Familie, meine Firma, meine Freizeit.

Jörg
Sellmeyer

that is, You ermittelst not not yourself The Startzeiten the machine, separate get only a list with the Arbeitszeiten the technician?
or erfaßt You yourself of your program each Arbeitszeiten the Bediener?

then müßtest You two separated Erfassungen manage:

list1 erfaßt The on- and Auszeiten the machine, list2 erfaßt The Start- and Endzeiten the technician.
In list1 can You then The Gesamtlaufzeit the machine to charge.
If you only The data have, The You supra wrote have, must You The Überschneidungen calculate and from the Gesamtsumme take away:
08:32 > 10:47 = 75mins
09:12 > 10:31 = 79mins
If no holes between Start- and Endezeit is, is the Gesamtzeit = Startzeit[1] > Endezeit[n]
you mußt means always The holes between Endezeit and new Startzeit find and can The times between add.

Edit: OK - Gerhard was faster and detail. the comes, if one in between yet what other power.

Windows XP SP2 XProfan X4
... und hier mal was ganz anderes als Profan ...

Gerhard
Praher

Gräm you not Jörg - the can each time occur.

Windows XP Pro, SP3
Jetzt: XProfan 11
Was ich liebe sind 3 "F": meine Familie, meine Firma, meine Freizeit.