Your math is O.K. - you just need a factor of 24:
8/16/2005 11:31
8/15/2005 9:30
is really
38580.47986
38579.39583
the difference is:
1.084027778 days
or 26.01666666 hours
--
Gary's Student
"dtencza" wrote:
I realized after I posted this that Cell A2 should say '8/16/2005 11:31 AM'
in my example.
I have the cell formatted the way I want, I just can't get the calculation
correct if the dates span over a day If anyone has made a formula that does
this and can share it, I'd be really grateful.
"JE McGimpsey" wrote:
One way:
Format/Cells/Number/Custom [h]:mm
In article ,
"dtencza" wrote:
I would like to calculate the difference between two dates and times and have
the result be in hh.mm.
So if in Cell A1 I have '8/15/2005 9:30 AM'
and if in Cell A2 I have '8/16/2005 11:17 AM' then...
I would want the result in Cell A3 to be 26:01.
Can anyone tell me what formula I would use to do this? My boss asked me
just a few minutes ago!
|