[AccessD] Time Conversion

Gustav Brock Gustav at cactus.dk
Tue Aug 1 05:52:41 CDT 2006


Hi Paul

The easiest method is to convert the time value to a double:

  dblHours = CDbl(datTime) * 24

For 
  datTime = #4:30# 

it will return 4.5 and so on.

/gustav

>>> paul.hartland at fsmail.net 01-08-2006 12:26:50 >>>
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




More information about the AccessD mailing list