Omit the am/pm suffix since your using a 24 hour clock. 16:43 can only be a
pm entry so your pm suffix is what's causing the #VALUE error.
--
Kevin Backmann


"jbly" wrote:

I'm still not getting it. It still has the same value and is giving #VALUE!
in the calculation.

Jason

"Kevin B" wrote:

Use the calculations that you indicated (A2-A1) but format the cell using the
following Time format:

[h]:mm:ss

Select the result cell, click FORMAT in the menu and select CELLS. In the
FORMAT CELLS dialog box locate the CUSTOM category in the category pane and
then locate the above format in the TYPE: list box. You can delete the ':ss'
if you do not want to see the seconds displayed.
--
Kevin Backmann


"jbly" wrote:

I can't seem to find it in the help. How do I calculate time difference? We
have a network in/out board. I get a report of when I clocked in and out for
the day. I want to paste this into Excel and have it calculate how much time
I worked. It comes in as:

A1 07:38 AM
A2 10:55 AM
A3 12:01 AM
A4 16:43 PM

I want it to calculate A2-A1 and A4-A3. Please help