none
Adding time column? RRS feed

  • Question

  • Hi,

    I have a report that displays a time column like this:
    0:00:00
    0:26:55
    0:52:39
    0:00:00
    0:21:48
    0:46:14
    0:29:22
    0:29:22
    0:23:51
    0:23:51
    0:17:49
    1:03:09
    1:00:12


    I want to add up those times into a grand total. I tried SUM, but that gives #error.

    Anyone have ideas about this?

    Thanks!
    Monday, September 24, 2007 8:39 PM

Answers

  • Yes I think so... This may not be the only way but it will probably work:

     

    Code Snippet

     

    =Sum(DateDiff(DateInterval.Second,

         CDATE("1/1/2000 00:00:00 AM") ,

         CDATE("1/1/2000 " & Fields!TimeValue.Value & " AM"))

     )

     

     

    HTH,

     

    >L<

    Tuesday, September 25, 2007 4:15 PM