By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Units of Time calculations

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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:
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.


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.