Totals on date/time fields

[Jackie_(Guest)]

Hi____I was a good R&R user in the days of Arpeggio and have now ^come back^ to version 10. In the old days I had to convert all my date/time fields to seconds to total them and then convert them back again. Is this still the case in version 10? If not, can someone tell me how to do it now?____Thanks____Jackie

[kfleming]

You would need to convert to some format that can be totaled (such as seconds which is a summable numeric) in the manner that you want. For datetime fields, I think that only count, min and max are available.__Kathleen__R&R Support

[Jackie_(Guest)]

Thanks Kathleen____Can you tell me the function for converting the seconds back into hours, minutes and seconds____Many thanks

[Jackie_(Guest)]

Never mind - I^ve spotted the STOC function - thanks anyway