Time Headache

[Lee J]

I have a problem with a time calc

i have three fields

tmTotal calc tmUnit * 60

tmSumTotTime calc sum(tmTotal)/60

tmUnit number

My summary answers are all wrong even if I assign tmSumTotTime as a summary field

manually on my calculator it works out correct, I must be missing something here Help!!!

cheers

[dylan]

Byte, I don't understand what you're trying to do. What are:

tmTotal calc tmUnit * 60

tmSumTotTime calc sum(tmTotal)/60

tmUnit number

You say they're fields, but they contain calculation formulas. You don't say what you're trying to work out. No-one here can help you without more information.

[Lee J]

No problem, after spending time thinking about how I should post my reply to your comments the answer came to me in a flash.

p.s What part of Manchester are you from?