hh:mm:ss field not subtotaling

[mindbender]

I have a time field that is in seconds. I am using the following to format it to hh:mm:ss but when I export it and try to subtotal it in excel it always returns 00:00:00.

Prev_Week_TT_In: Format(([TT In]/86000),"hh:nn:ss")

I can go to text to columns and change the column so that the sum calculation works in the subtotal but I would like to not have to do that.



Is it the formatting I am using that is causing the issue?

I see this result I would like to see

00:45:12 00:45:12
00:32:24 00:32:24

00:00:00 00:77:36

As always, Thanks in advance!

[ranman256]

you dont add time that way. Usu you use DateAdd() but you are summing.
convert it to like units (seconds) then sum.

or get the DateDiff()

[mindbender]

sorry I may have not explained myself quote right.

The field [TT In] contains the time in seconds. I then format the seconds to hh:mm:ss using the formula above.

When I try to subtotal the hh:mm:ss values together for multiple rows it returns 00:00:00 instead of the total time in hh:mm:ss as I would expect

hope I didn't make it worse