[AccessD] Time Conversion

Thanks for all replies sorted now, I had already tried the CDBl function ans was getting errors, found out it was cause the hours were returning in a string and not a date format.....What I would do without this list I do not know.

Paul Hartland





Message Received: Aug 01 2006, 12:03 PM
From: "MastercafeCTV" 
To: "'Access Developers discussion and problem solving'" 
Cc: 
Subject: Re: [AccessD] Time Conversion

On access one day = 1
1 Day= 24h 
If you want this values in format Hour then only need multiply by 24

csng(#15:30:00#)*24 = 15.50

Hope this simple function can help you :-)

Juan Menendez
www.mastercafe.com
info at mastercafe.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: martes, 01 de agosto de 2006 12:27
To: accessd
Subject: [AccessD] Time Conversion
Importance: High


To all,

Sorry for the post I am sure I have seen this before but must be going mad
as can't seem to find the examples, basically what I want to do is convert
the hours I get in my table 4:15, 4:30, 4:45 to 4.25, 4.50, 4.75 etc....Can
anyone point me to this function please.

Thanks in advance for any help on this.

Paul Hartland
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com