NebraskaGod
Technical User
Is it possible to change a time to a decimal? If so, how would you go about it?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I change a sum of time into a decimal?
- Thread starter NebraskaGod
- Start date
- Status
MichaelRed
Programmer
Actuall, date data type IS a 'Decimal' type. It is (in general) the same as a double. It is only the desigantion of date (type) which generates the weird display (e.g. Now returns "12/12/2001 5:39PM"
Just try ? CDbl(Now) to get the generic "decimal".
?Cdbl(now)
37238.7361574074
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
Just try ? CDbl(Now) to get the generic "decimal".
?Cdbl(now)
37238.7361574074
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
- Status
Similar threads
- Locked
- Question
- Locked
- Question