Re: Measure between date time A to date time B

Hi

Subtract the later from the earlier and format the result as either
[hh]
for hours or
d "days" h " hours"
as days and hours.

Andy.

<stuacoo@xxxxxxx> wrote in message
news:1150282498.077002.142870@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Morning Guys,

Im slowly going insane with what appears to be a very simple
calculation.

Can someone please assist with the following:

I am trying to work out ow long a process takes from date and time A to
date and time B returning the value of how long a process takes in days
and hours, or just hours.

Many Thanks if you can assist.

Stewart :)



.

Relevant Pages

  • Re: Find in a date range
    ... The equivalent Script would then be something like: ... Assuming you mean a calendar month the calculation part of the Set ... Field above has to work out the current month and subtract 1. ... Captain) instead of a year month day or day month year format. ...
    (comp.databases.filemaker)
  • Time Calculations
    ... I need a calculation to subtract the start time from the finish time when the ... time is in the format of hours:minutes such as Start time as 1:40, ...
    (microsoft.public.project)
  • Re: Measure between date time A to date time B
    ... Ooops! ... 'subtract the later from the earlier' should read 'subtract the ... Subtract the later from the earlier and format the result as either ... Stewart:) ...
    (microsoft.public.excel.misc)
  • Re: Form Protection with Excel Object Embedded
    ... the best field to base the calculation on might be the one in the example titled 'Calculate the # Days Difference ... The date input format is of no consequence, provided both dates have a day, month and year- you might want to enforce this via the ... Excel workbook, though. ... At most, you'll need to insert a paragraph break immediately before the workbook, then format the workbook ...
    (microsoft.public.word.application.errors)
  • RE: Phone number query in query form
    ... this is to create a calculated field in the query ... messagio e provero di spiegarmi meglio. ... form of calculation with the data or sort it in some calculated ... When I type the value, in the mentioned format, in the query I get the data, ...
    (microsoft.public.access.forms)