Hello, I have a table with information about time that have been spended by every employee.
I want to find a summ of all spended time in a day every employee. I want to get the summary table:
Please try the below calculation
convert the date time to seconds and you can sum them up
DATEPART('hour',[Period]) * 3600 +
DATEPART('minute',[Period])*60 + DATEPART('second',[Period])
Retrieving data ...