View Single Post
  #7  
Old November 23rd, 2006, 08:12 PM posted to microsoft.public.access.queries
Marco
external usenet poster
 
Posts: 535
Default Problem is sum hours, because when cross 24h start in zero

Try to past this number into a excel sheet. Then format this cell, goto
Format cells an in custom use this kind of format [h] it will convert the
numbers into hours.

Marco






"Rick Brandt" wrote:

"Marco" wrote in message
...
Yes. the comma the decimal point character in my regional settings.

Can you help me?


So you have a total sum of hours with a value of 45,75399583, which I'm
interpreting to be a bit over 45 and 3/4 hours. Just how do you want that
displayed?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com