Date - Help!!!!!!!!

Hi,

Does anyone have some code that converts a date\time datatype into a double datatype.

eg. convert 9:45pm into 21.75

Please help as is urgent.

Thanks.

Text1 = CDbl(Time) * 24


David Paulson

That works great. However, there is one more problem. The time is coming from a date/time field and therefore I need to first split the time away from the date.

DO YOU KNOW HOW TO DO THIS?

THANKS HEAPS.

debug.Print formatdatetime(now,vbShortTime)

David Paulson