October 15, 2013 at 11:05 am
Hello,
I have a report which has times in the following format: (11:20:01). I need to have a subtotal row added which has an AVG of all the times. I am new to SSRS, so I have no idea how to do this. I have included a column from the excel file that I am reverse engineering. Those are the columns in the report and I need to AVG them. Any help would be appreciated.
Thanks
00:00:53
00:00:18
00:00:27
00:01:01
00:00:22
00:00:20
00:00:34
00:00:22
00:00:22
00:00:32
00:00:20
00:00:20
00:00:34
00:00:20
00:00:19
00:00:25
00:00:11
00:00:29
00:00:19
00:00:20
00:00:41
00:00:28
October 20, 2013 at 7:14 pm
I have a report which has times in the following format: (11:20:01). I need to have a subtotal row added which has an AVG of all the times. I am new to SSRS, so I have no idea how to do this. I have included a column from the excel file that I am reverse engineering. Those are the columns in the report and I need to AVG them. Any help would be appreciated.
Thanks
00:00:53
00:00:18
00:00:27
Dates are stored as floating point numbers with the date being represented as the number of days from some starting date, and the time being the number of (I think) milliseconds since midnight (Hour 0, Minute 0). You could just do the easy thing and convert these to Time Span measurements (pretty much what you showed, but multiplying by 3600 for hours and 60 for minutes and then totalling everything. That is a proper number, and you can do averages and then re-format it as hours and minutes in your report.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply