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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|