Announcements
cancel
Showing results for
Did you mean:
Not applicable

## How do I Average Hours? (Como faço Média de Horas ?)

Good afternoon!

I have a great difficulty to get to average hours, have the following table:

NOMECOMPETÊNCIAHORA INICIALHORA FINALTEMPO GASTO

WILLIAN

03/201508:00:0009:00:0001:00:00

WILLIAN

03/201508:00:0010:00:0002:00:00
WILLIAN03/201509:00:0012:00:0003:00:00
ALEXANDRE03/201508:00:0009:00:0001:00:00

I want to register on a graph, the average time that William and Alexander took to carry out the process. And so to know who took longer and slower, having as parameter the time spent and competence. It's possible?

Boa tarde ! Estou com uma dificuldade imensa para conseguir calcular a média de horas, tenho a seguinte tabela:

(Table)

Quero registrar em um gráfico, o tempo médio que o Willian e o Alexandre demoraram para realizar o processo. E assim saber quem demorou mais tempo e mais devagar, tendo como parâmetro o tempo gasto e a competência. É possível ?

2 Replies
MVP

How do you imagine the average would be calculated?

(HORA INICIAL + HORA FINAL + TEMPO GASTO)/3

Not applicable
Author

It looks like from sample data the last column Tempo Gasto contains the difference between 4th and 3rd columns. So, average on that should suffice. Also, it looks like the time format is hh:mm:ss.

Hence put your first column NOME in dimesion tab and in expression

1) change your 5th column to lower granuality, say minutes using:

(time#(TEMPO GASTO,'hh:mm:ss')) *60 + Minute(time#(TEMPO GASTO,'hh:mm:ss'))

2) Now take an Avg of this result from step1.

Community Browser