|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#11
November 24th, 2006, 01:07 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Problem is sum hours, because when cross 24h start in zero
"Marco" wrote in message
... Hi. Well with that code you I'm approaching of what I need. But instead of counting 83h counts 6:367h. Any idea? I still don't understand. You indicated that the number was a sum of hours and as a general number you have 45 plus some fractional amount. To me that means you have a total of 45 hours plus a fraction of an hour. How do you expect to get 83 from this number? -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com 
|
|
#12
November 24th, 2006, 01:15 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Problem is sum hours, because when cross 24h start in zero
"Marco" wrote in message
... John, I've got this number and I want that appears 149. And how does one get from 45.75399583 hours to the number 149? -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#13
November 24th, 2006, 01:57 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Problem is sum hours, because when cross 24h start in zero
Hi Rick,
Sorry, maybe I said something wrong this 6,21264767199444 is 149 hours. Put this number in a excel cell and then format with this code [h], as you know, goto custon cell format. Thanks for your pacience. Marco "Rick Brandt" wrote: "Marco" wrote in message ... John, I've got this number and I want that appears 149. And how does one get from 45.75399583 hours to the number 149? -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#14
November 24th, 2006, 02:32 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Problem is sum hours, because when cross 24h start in zero
Rick, can I send you an e-mail?
"Marco" wrote: Hi Rick, Sorry, maybe I said something wrong this 6,21264767199444 is 149 hours. Put this number in a excel cell and then format with this code [h], as you know, goto custon cell format. Thanks for your pacience. Marco "Rick Brandt" wrote: "Marco" wrote in message ... John, I've got this number and I want that appears 149. And how does one get from 45.75399583 hours to the number 149? -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#15
November 24th, 2006, 02:58 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Problem is sum hours, because when cross 24h start in zero
"Marco" wrote in message
... Hi Rick, Sorry, maybe I said something wrong this 6,21264767199444 is 149 hours. Put this number in a excel cell and then format with this code [h], as you know, goto custon cell format. Thanks for your pacience. Well then what you have then is a sum of DAYS equaling 6.21...., not a sum of hours as you stated before. This expression Fix(YourValue*24) will give you the number of whole hours (149). -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#16
November 24th, 2006, 06:17 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Problem is sum hours, because when cross 24h start in zero
Thanks, it worked very fine.
How did you get there? Marco "Rick Brandt" wrote: "Marco" wrote in message ... Hi Rick, Sorry, maybe I said something wrong this 6,21264767199444 is 149 hours. Put this number in a excel cell and then format with this code [h], as you know, goto custon cell format. Thanks for your pacience. Well then what you have then is a sum of DAYS equaling 6.21...., not a sum of hours as you stated before. This expression Fix(YourValue*24) will give you the number of whole hours (149). -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#17
November 27th, 2006, 02:33 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Problem is sum hours, because when cross 24h start in zero
Marco wrote:
Thanks, it worked very fine. How did you get there? Once I determined that you had a value representing a number of days instead of a number of hours the math was pretty easy to figure out. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
