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

If cells hold date/time data the:

=(EndDate-StartDate) and format as [h]:mm to give time in hours and minutes

HTH

" wrote:

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

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

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)

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

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

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

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