Re: Calculating elapsed time problem

Nope, wrong. Dividing by 60 would yield minutes.

That should be

ElapsedTime = ( TSEnd - TSBegin ) / 3600

Matt

Matt Wills wrote:

> The person who posted the CF left it pretty much up to the user to
> figure out how to use it.
>
> With fields named TStampBegin, TStampEnd and Format in place the CF
> will behave like a calculation to display the time elapsed between
> TStampBegin and TStampEnd, in a format determined by the value of
> Format.
>
> The last Case statement gives you the permitted values of Format:
> "Minutes, Hours, Days or String."
>
> In the end, though, all this calc does is subtract TStampBegin from
> TSEnd to arrive at ElapsedSeconds, then divides that by a certain
> number to display the result in your preferred way. If Format is
> "Hours", ElapsedSeconds is divided by 60, and there's your answer.
>
> If wx.yz hours is all you'll ever need, why not make your ElapsedTime
> = ( TSEnd - TSBegin ) / 60 and be done with it?
>
> Matt
>
> Joel L wrote:
>
> > I did change my table names to coincide with the formula names. I
> > even added a field called "format." None of this worked. What type
> > of information goes into the "format" field - it was not part of my
> > original table? None of this gives me the results shown on that
> > website.
> >
> >
> > On Tue, 03 Jan 2006 09:35:31 GMT, "Matt Wills" <Im@xxxxxxxx> wrote:
> >
> > > You're converting a CF to a calculation. You need to make sure you
> > > have fields in your file that correspond with the variables
> > > defined in the CF.
> > >
> > > You need to have fields named TStampBegin, TStampEnd and Format,
> > > or adjust the calculation to reflect the actual names of the
> > > fields.
> > >
> > > Matt
> > >
> > > Joel L wrote:
> > >
> > >> In attempting to copy and paste the formula into my calculation
> > field >> "Elapsed Time," FM highlights "format" in that formula and
> > tells me >> "The specified field cannot be found." What am I missing
> > here? >>
> > >> JL
> > >>
> > >> On Mon, 02 Jan 2006 21:29:29 GMT, "Matt Wills" <Im@xxxxxxxx>
> > wrote: >>
> > >> > See if this CF (used as a calculcation) might solve your
> > problem. >> >
> > >> > http://www.briandunning.com/cf/59
> > >> >
> > >> > Matt
> > >> >
> > >> > JoelL wrote:
> > >> >
> > >> >> In Version 8, I'm trying to create a sign in/sign out database
> > to >> be >> used in touch screen (Kiosk) mode for our Head Start
> > parents. >> >>
> > >> >> The first table includes a three-digit student ID number,
> > student >> name >> and room. The second table ("Sign IN") includes
> > the student >> ID number >> for the relationship and lookup fields
> > for name and >> room. The third >> table ("Sign OUT") includes the
> > same information >> but will be used as >> the name implies. The
> > last table is the column >> report on which I need >> to show
> > student number, name, in date and >> time, out date and time and >>
> > elapsed time in number of hours and >> minutes. To get a subtotal
> > of >> hours and minutes, I will sort by >> classroom and student
> > name. >> >> >> I am having trouble calculating the elapsed time.
> > I've tried using >> >> "creation date and time" fields. I've tried
> > using a time stamp >> field >> and inserting the current date and
> > time by script. Either >> method seems >> to provide the correct
> > date and time on the >> respective "In" and "Out" >> records but I
> > can't seem to get the >> elapsed time to calculate and >> appear on
> > the report in the format - >> example "4 hours, 20minutes" (or >>
> > "4.33" hours would be fine). What >> am I doing wrong - is there a
> > better >> way to do get this >> calculation?



--

.

Relevant Pages

  • Re: Format a field for Time, but as duration?
    ... "Matt D Francis" wrote: ... >> The article suggests that the Number field is the best format, ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: is mapping a floppy drive possible in win2k server?
    ... You can't format a mapped drive. ... Ok, Matt, here's the update: ... > prompting to format the drive first, and then write the data to floppy. ... >>walk to the server and create the floppies from the 'a' drive. ...
    (microsoft.public.windows.server.general)
  • Re: Excel Timesheet
    ... Matt Wrote: ... >> Just subtract the lower from the higher, and format that cell as time ... >> then just add the two totals cells together, ... Try formatting the cell as:mm ...
    (microsoft.public.excel.misc)
  • Re: Calculating elapsed time problem
    ... With fields named TStampBegin, TStampEnd and Format in place the CF ... >> You're converting a CF to a calculation. ...
    (comp.databases.filemaker)
  • Re: Urgent: Exporting Access into Excel
    ... Sorry - just realised that the date is displayed in US format, ... Doh! ... Paul C wrote: ... >Hi Matt, ...
    (microsoft.public.access.conversion)