Units of Time calculations

[Heather]

I have three fields each containing a time unit ie direct, indirect
and misc. I am trying to calculate a total (sum) of all. If the data
type is 'double' number, how do I convert the total so it calculates
the correct hours and mins. Or am I totally incorrect in this
process?
Any help greately appreciated.
thank you.

[Peter Russell]

Re: Units of Time calculations

It's not clear to me what your fields contain.
Do they contain a number of hours expressed to 'n' decimal places?

Or are you saying they contain a time value which displays as
hours:mins:secs but which you know to be a double number really?

Regards

Peter Russell




Heather previously wrote:
[color=blue]
> I have three fields each containing a time unit ie direct, indirect
> and misc. I am trying to calculate a total (sum) of all. If the data
> type is 'double' number, how do I convert the total so it calculates
> the correct hours and mins. Or am I totally incorrect in this
> process?
> Any help greately appreciated.
> thank you.
>[/color]