Time Elapsed formula

[KC]

I need help figuring out how to create a formula that
will give me the amount of time elapsed (in hrs & min)
between a start time and a stop time. I have tried
converting the times to a serial number and then
subtrating them with the TIME(), but it doesn't seem to
work. And MINUTE() doesn't account if one hour is diff
than another.

I would like the final value of this calculation to be
displayed in hours and minutes. I would also like to be
able to add the entire number of hours spent on things
for an entire day and have the result formatted in tha
same way.

Please hlep if you can!

TIA,
KC

[Max]

Try entering in C2: =ABS(B2-A2), and copy down col C. This
assumes the start & stop times are in cols A and B, i.e.
in A2 & B2 downwards.

Assuming your last data row is 5, enter in C6
:=SUM(C2:C5) to total

Select col C
Click Format>Cells
Select "custom" under "Category"
Type [h]:mm (including the right & left square brackets
for the "h") to custom format the cell

hth
Max

>.
>

[KC]

Worked great! TY!

--KC

A2: 3:00 PM (formatted TIME cell)
B2: 3:19 PM (formatted TIME cell)
C2: =ABS(B2-C20.01
"Max" <demec...@yahoo.com> wrote in message
news:07f501c309f9$6759c930$3001...@phx.gbl...

[KC]

Hey Max... one thing though... how do I compensate for times that may span
two days? i.e. the start being at 11:36 PM on one day and the end being at
12:03 AM the next? I keep getting a 23 hour result from that calulation...
does it need to go into an IF()?

--C

"Max" <demec...@yahoo.com> wrote in message
news:07f501c309f9$6759c930$3001...@phx.gbl...

[Phobos]

You need to include dates and times then, your formulas would stay the same
but your cell formatting would need to change to something like:

dd/mm/yy hh:mm

P

"KC" <k...@pacbell.net> wrote in message
news:OefQ4kpC...@TK2MSFTNGP12.phx.gbl...

[Max]

Hi, just custom format the start/stop cols A & B as:
m/d/yy h:mm AM/PM

Using your example situation, if you have entered:
in A2: 4/24/2003 11:36 PM
in B2: 4/25/2003 12:03 AM

C2 will return the correct 0:27

hth
Max