Displaying Time as in Total amount of time

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: MDPILWL (MDPILWL_at_discussions.microsoft.com)
Date: 01/23/05 

Date: Sat, 22 Jan 2005 22:57:01 -0800

I'm not sure if this is where I post this but here it goes.

I have already imported the data from an excel file, in excel it has the
ability to display this field as the total amount of time sense the start of
the clock for example "66:21:22" is 66hrs 21mins and 22secs.

The raw number in excel is 2.76483796296088 and after importing it as a
datetime field it is displaying as "1/2/1900 6:21:22 PM"

What I need to do is display it as a result from a query as the number of
hrs mins and secs the way excel did hh:mm:ss.

thanx in advance.

Relevant Pages

  • Re: Convert from WrapText
    ... this amount of data from an Excel cell (without widening the Access ... So ideally I wish to take the workbooks into Access and display ... here is the code used for importing the Excel data: ... >> Access would treat each of these rows as a recordset when imported, ...
    (microsoft.public.excel.programming)
  • Re: linking or merging to Excel
    ... you can do the EXCEL save as via Automation. ... the data type is correct. ... Otherwise, you could use Automation to open the EXCEL file, read each row ... prior to importing but it still imports as a number. ...
    (microsoft.public.access.gettingstarted)
  • RE: Prompt form launching report with subreport
    ... My database imports data from excel files. ... save formatted excel file, close it and then do transferspreadsheet. ... Anyway, this importing is once a month thing, so my boss doesn't quite mind ... I prefer the form to keep the report clean. ...
    (microsoft.public.access.reports)
  • Re: Message from importing an excel file
    ... The Excel file is on two sheets, ... first sheet looks like a form and the second sheet holds the data from sheet ... especially since I'm not really familiar with Excel or even Access. ... Everything goes where its suppose to go, but whenever I keep importing ...
    (microsoft.public.access.externaldata)
  • Re: Export to Excel setting field types
    ... You are grabbing your Excel Spreadsheet ... "Gina Whipp" wrote: ... client excel file match to my table fields, but I will need to find the ... that only for importing? ...
    (microsoft.public.access.formscoding)