Hours = DateDiff("h",[StartTime],[StopTime])
Minutes = DateDiff("m",[StartTime],[StopTime]) - (Hours * 60)Tobi -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of brazilianbound Sent: Thursday, December 08, 2005 11:21 AM To: [email protected] Subject: [AccessDevelopers] Caculating Time in Access Qry Morning! I'm trying to get hours and minutes in my calculted field in my query but this is giving me decimal hours. Calculate Time: DateDiff("s",[StartTime],[StopTime])/3600 Thanks! Clayton Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
