how to calculate average time for time values in mm:ss ?

[#1]

i have a column 'baggage time' having values like,

01:23

06:16

01:50

00:28

etc.

i need to plot average baggage time on y axis of a chart, any idea how to do it ?

thanks.

[#2]

Hi, When you use LAST BAGGAGE ON BELT-1st BAGGAGE ON BELT, you should make sure the result is absolute value. you can use logic:

Baggage_Time_ss= if(Baggage_Time_ss<0, Baggage_Time_ss+86400, Baggage_Time_ss)

I should suggest you store the date about LAST BAGGAGE ON BELT, not only time.

[#3]

=time(avg([baggage time]),'hh:mm')

Try this, this should work

[#4]

all i want to plot is , average time duration(not actual time) like this.

PFA

[#5]

try below reload script:

LOAD DATE,

  month(DATE)as Month,

  week(DATE) as Week,

     TERMINAL,

     HANDLERS,

     [FLIGHT NO],

     [START DUTY],

     [BAY NO.],

     [BELT NO.],

     ETA,

     [THUMBS UP TIME],

     [TIME AT BAGGAGE AREA],

     [TIME AT BELT],

     [1st BAGGAGE ON BELT],

     [LAST BAGGAGE ON BELT],

     Baggage_Time,

     if(Baggage_Time_ss<0,Baggage_Time_ss+86400,Baggage_Time_ss) as Baggage_Time_ss,

     Delay_time,

     Delay_time_mm,

     Delay_time_ss,

     Processing_Buffer_time,

     Delivery_Buffer_time,

     [MIXED LOAD - INCL TRANSFER BAGGAGE (T.B)],

     [NO. OF STAFF HANDLING],

     [BAGGAGE HANDLE FACING OUT],

     [SUM OF TROLLEYS & CONTAINERS],

     [1st BAGGAGE ON BELT1],

     [LAST BAGGAGE ON BELT1],

     [TIME 1st BAGGAGE ON BELT - THUMBS-UP TIME],

     [TIME LAST BAGGAGE ON BELT - THUMBS-UP TIME],

     [Pass = P Fail = F (1st BAGGAGE)],

     [Pass = P Fail = F (LAST BAGGAGE)],

     [PEAK / NON-PEAK]

FROM

GOEM_Baggage.xlsx

(ooxml, embedded labels, table is [02_Baggage Presentation DataSet]);

[#6]

Hi,

Use this .

may be help you .

regards

Vimlesh

[#7]

the same when applied to baggage time chart , is not giving right output

[#8]

hi,

send chart with expression.

Regards

Vimlesh

[#9]

PFA

thanks