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

J

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!
 
J

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!
Click to expand...


.
Click to expand...
 
T

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]
 
S

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

Ron Rosenfeld

Any other ideas as this didn't work?
Click to expand...

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
 
Top