Measure between date time A to date time B

S

stuacoo

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

Toppers

If cells hold date/time data the:

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

HTH
 
G

Guest

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.
 
B

Bob Phillips

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

Guest

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

Andy.

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.

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 :)
Click to expand...
Click to expand...
 
S

stuacoo

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.


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.

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 :)
Click to expand...
Click to expand...
 
G

Guest

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

Andy.

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.


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.

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 :)
Click to expand...
Click to expand...
Click to expand...
 
Top