View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Measure between date time A to date time B

Ooops! 'subtract the later from the earlier' should read 'subtract the
earlier from the later' !!

Andy.

<Andy wrote in message ...
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.

wrote in message
oups.com...
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 :)