Need formula help - date/time, minus date/time

[Janet]

Hi,

I am trying to find the difference in hours from one date
and time to another. I realize that I cannot subtract
one cell from the other as it olny looks at the hours and
not the days. Any ideas?

Thanks!

 

[Andy B]

Hi

You can subtract the ealier date from the later and format the result as
[hh].

 

[Janet]

Any other ideas as this didn't work?

-----Original Message-----
Hi

You can subtract the ealier date from the later and format the result as
[hh].

--
Andy.

Hi,

I am trying to find the difference in hours from one date
and time to another. I realize that I cannot subtract
one cell from the other as it olny looks at the hours and
not the days. Any ideas?

Thanks!

.

 

[theillknight]

This worked for me.

A1: 7/1/2004 8 PM
A2: 6/15/2004 2 PM
A3: =A1-A2

I then formatted A3 using custom formatting, [hh]

 

[SidBord]

Time subtraction problems will drive you cookieputz. If
you can write a Visual Basic macro, you take a lot of
intermediate steps, like converting days to hours. You
might look into formatting with brackets ("[ ]"). I'll
have to do some digging. Try formatting your result cell
as [h]:mm, then do the subtraction. That may be what you want.

 

[Ron Rosenfeld]

Any other ideas as this didn't work?

It absolutely should work if you did it as recommended.

Post details on exactly what you did to try to implement Andy's suggestion, and
the results you obtained.


--ron