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

Yes, just add the "minutes" bit to your custom format. Thanks for the
feedback!

Andy.

wrote in message
oups.com...
Many Thanks for that andy, i guess just by adding in mm "minutes" would
include the minutes in this calculation?

Many Thanks for both of your assistance.


<Andy wrote:

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 :)