Date/Times are numbers.The whole number part of the number is the number of days since 12/30/1899. The decimal part is the part of a day. 0.5 is a half day which is 12 hours.
To convert a date/time value to days do nothing. To convert to hours, multiply by 24 since there are 24 hours in a day. To convert to minutes, multiply by 1440 (24*60).
You need to determine your time unit of measure.
Duane Hookom MVP
MS Access
----------------------------------------
> To: MS_Access_Professionals@yahoogroups.com
> From: bob@alternatefinishing.com
> Date: Thu, 11 Apr 2013 14:23:10 -0400
> Subject: RE: [MS_AccessPros] Converting time to a number
>
> Here is information on how Access stores dates
> http://support.microsoft.com/kb/210276
>
> Access stores dates the same way Excel does.
>
> Bob Peterson
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jerry Mathers
> Sent: Thursday, April 11, 2013 2:03 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Converting time to a number
>
> I have a field that is a date datatype (short time). Lots of data have (has?) already been entered. It was a mistake to use a date datatype so is there a reasonably easy way to convert all of the times to numbers. I know that Access stores dates and times in an unusual way and everything I've tired so far gets me "interesting" results.
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar