Calculate Daily Hours

[Nadiyah]

Hello

I'm trying to develop a dashboard containing the daily spent hours for all the employee 

i tried using sum(daily spent hours) but it's not working 

please see the below screenshot

can you please help me 

[vinieme12]

that would be because the field is being loaded as TEXT and not as TIME

load the field as below

,time(time#('9:00','H:mm')) as [DailyHourSpent]

you can then use the same expression

SUM([DailyHourSpent])

[Nadiyah]

thank you for answer 

i tried your solution here the output 

[Mark_Little]

Hi @Nadiyah 

If @vinieme12  answer is not correct please supply some detail, share some example data and expected results. What dimensions are you using.

[Nadiyah]

I want to calculate the working hours for all the employees, I used the daily column which already exists in the excel sheet, and already calculated the spinning hours for every employee on a daily basis.  so I want to sum up all the values to get the working hours for all the employees

[vinieme12]

you need to format it as interval when summing time 

=interval(sum(dailyhourspent),'H:mm')

[vinieme12]

example below

temp:
Load recno() as rownum, interval#(hourspent,'H:mm')  as hourspent inline [
hourspent
9:00
9:00
133:00
];

or