Re: How To Convert Number Field To Time Field For Calculation?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 01/20/05 

Date: Thu, 20 Jan 2005 04:18:52 -0800

Seikyo

Access doesn't have a "time field" data type. It does have a date/time data
type.

Are you saying that your data is an integer or other numeric data type? If
so, to use the date/time functions, you'll also need a date. 

-- 
Good luck
Jeff Boyce
<Access MVP>
"Seikyo" <Seikyo@discussions.microsoft.com> wrote in message
news:E1AC96AD-8255-4E35-8FB0-9A44695FD225@microsoft.com...
> I got my data in 24 Hrs (Number Field) like 800 Hrs, 1400 hrs, 1432 Hrs.
> Anyone know how do I convert the above to time field, hh:nn, so I can do a
> calculation to get the duration.  I am aware that if the field are all in
> time field, we can use the Elapsed Time function to get the intervals.

Relevant Pages

  • Re: date and time syntax
    ... Ken Snell ... > I have a time field that holds appointment time. ... smalldatetime for this column. ... > I get an "wrong data type" error with both. ...
    (microsoft.public.access.formscoding)
  • Re: Btrive time fields in Crystal Report dont display properly
    ... use the Crystal 8.5 merge module in Installshield developer. ... Data Type 4 is definitely a standard TIME field. ... >> This app was first developed in 1996, and we started with Smithware. ...
    (comp.databases.btrieve)
  • Re: Btrive time fields in Crystal Report dont display properly
    ... Data Type 4 is definitely a standard TIME field. ... > This app was first developed in 1996, and we started with Smithware. ... >>> required DLL for this function. ...
    (comp.databases.btrieve)
  • Re: Summarizing Date and Time
    ... If you want to create a date out of the date/time data you can use ... seperate start time field, a seperate end time field, and a total time field. ...
    (microsoft.public.excel.worksheet.functions)