Summing hours to show more than 24 hours

[mohecan84]

Hi Everyone,

I know this is not a challenging one for you but I am really having some difficulty with this.

I am trying to calculate the total time spent on a task but it seems that the SSRS statement I am using =FORMAT(TIMESERIAL(0,0,(sum(Fields!AHT.Value))),"HH:mm:ss") does not go over 24 hours. I have been able to amend this to show the days, then hours etc but that is not the format that I require the total to reflect.

Any help would be greatly appreciated.

kind regards,
Murtadau Gabier

 

[xlbo]

this seems to be pretty comprehensive:

http://social.msdn.microsoft.com/forums/en-US/vbide/thread/1697f74e-1f28-4456-9f67-f77b33afa15e

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question