I IanT Registered User. Local time Today, 20:13 Joined Nov 30, 2001 Messages 191 Dec 1, 2001 #1 I am using the 24 hour clock to calculate time in a query, but access loops the total ie 25 hours would show as 1 hour. Can anyone advise me how to overcome this in a query!
I am using the 24 hour clock to calculate time in a query, but access loops the total ie 25 hours would show as 1 hour. Can anyone advise me how to overcome this in a query!
R Rich Guest Dec 1, 2001 #2 Try here for starters http://support.microsoft.com/default.aspx?scid=kb;EN-AU;q130514&GSSNB=1
A Andy D Guest Dec 7, 2001 #3 Fields in table [Date] [Time] [End Date] [End Time] Create a query and add these two fields Calculate total time Total: ([End Date]+[End Time])-([Date]+[Time]) Convert into time Converted Total: Int(CSng([Total]*24)) & ":" & Format([Total],"nn:ss")
Fields in table [Date] [Time] [End Date] [End Time] Create a query and add these two fields Calculate total time Total: ([End Date]+[End Time])-([Date]+[Time]) Convert into time Converted Total: Int(CSng([Total]*24)) & ":" & Format([Total],"nn:ss")
