Re: Measure between date time A to date time B

Just take the start from the end and format as [h]:mm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

<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: Use Sort method for 2002/2003 in 2000.
    ... Bob Phillips ... in the email address with gmail if mailing direct) ... Again in Excel 2000 I get the msg that the variable xlSortTextAsNumbers ...
    (microsoft.public.excel.programming)
  • Re: any UDF for sum or rounded product
    ... to gmail if mailing direct) ... number of factors and decimals - like a generic/productive formula. ... "Bob Phillips" wrote: ...
    (microsoft.public.excel.programming)
  • Re: AVERAGE function
    ... Bob Phillips ... (replace somewhere in email address with gmail if mailing direct) ... After posting, I went out for lunch (and a nice drop of Old Speckled ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Counting Values Across Columns
    ... to gmail if mailing direct) ... Bob Phillips Wrote:- ...
    (microsoft.public.excel.setup)
  • Re: Grouping patterns of numbers in cell
    ... Bob Phillips ... (replace somewhere in email address with gmail if mailing direct) ... Yes, I know 123,456,789 is the *format* for most of the world. ...
    (microsoft.public.excel.newusers)