Thread: Problem is sum hours, because when cross 24h start in zero
View Single Post
  #10  
Old November 24th, 2006, 01:06 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
John,

I've got this number and I want that appears 149.

Regards,
Marco




"John Vinson" wrote:

On Thu, 23 Nov 2006 08:19:01 -0800, Marco
wrote:

Hi. thanks for your reply. I already have the column hours in long integer.
I have this total sum: 45,75399583.

If it was in excel, I format in costum as [h] it will work fine. I wanted
to do the same in access, in querie or form. in excel I can get 1098 but not
in access.

Try

Fix([Total]) & ":" & Format(60*[Total] - Fix([Total]), "00")


John W. Vinson[MVP]