Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jhaney
Starting Member
33 Posts |
 Posted - 2010-12-07 : 12:43:31
|
| Not sure if I'm explaning this correctly but here goes. I have a data in a table report that is a calculated amount of time. =cdate(Fields!END.Value) - cdate(Fields!START.Value) (ex 10:45 am - 10:30 am = 00:15:00)I need to now average the results in the footer of the group. Time 00:15:00 00:20:00 00:25:00Avg 00:20:00Thanks in advance for any assistance.Joshua |
|
|
jhaney
Starting Member
33 Posts |
Posted - 2010-12-07 : 13:06:39
|
| Sometimes I think I have to post here before I figure something out, was very simple.=(Avg(cdate(Fields!READY.Value) - cdate(Fields!ARRIVED.Value)))this returns the integer of 10020000000 which converts to 00:16:42 now I just need to have the expression convert it to HH:mm:ss any ideas on that?ThanksJoshua |
 |
|
|
jhaney
Starting Member
33 Posts |
Posted - 2010-12-09 : 10:33:09
|
| Anybody got any ideas, I can't seem to figure out how to convert an integer to HH:mm:ssThanksJoshua |
|
|
|
|
|
|
Column average of calculated data