start and stop time

[ajsjoshua]

Hi,

I want to calculate the  Count of each part produced by hour of the day.

PFA

[Anonymous]

Hi

Is it like this ?

MachineNumber	Machines produced by hours
1	05:34:00
2	04:36:00
3	03:34:00
4	07:46:00
5	08:06:00
6	08:09:00
7	08:52:00

[Pulkit_Thukral · Accepted solution]

Hi Joshua,

Does the below graph fulfills your requirement ?

I have created a custom field "Hour" in scripting to achieve this .

Script :

LOAD MachineNumber,

     Start,

     Stop,

     Program,

     CoolantPumped,

     RPM,

     OpID,

   HOUR( DATE(Start,'h:mm:ss TT')) as Hour

FROM

HaasMachines.xlsx

(ooxml, embedded labels, table is Sheet1);

[ajsjoshua]

Hi Pulikit,

It should be based on the hour of the day.

Ex: if time is 5pm how much program completed lik that i want to show

[Pulkit_Thukral]

First Question :-Hour of the day will be based on Start or Stop Time.

Second Question :- condition for program completed ?