Your difference is exactly 6 days, so it looks as if your input cells
include dates, though you are displaying only the times.
--
David Biddulph

"cahabbinga" wrote in message
...
UPDATE: I've tried using the [h]:mm & the [hh]:mm formats for the TOTAL
HOURS WORKED cell, but it doesn't compute:

7:54 + 6:39 + 7:02 + 8:09 + 7:23 + 7:50 is equalling 188:57??

What am I doing wrong?? ARGH!!!


"cahabbinga" wrote:

I have a spreadsheet that has rows of employees. The header row lists
Name,
Mon, Tues, etc, through Friday, with TOTAL HOURS WORKED at the end. Each
row, under day of week listed the employee's work hours (ex: Under Monday
I
have 7:36 - they worked 7hrs and 36 minutes). How do I calculate the
TOTAL
HOURS WORKED for the week? I assume there is a formula, but I can't
figure
it out for hours:minutes worked per week. Thanks so much for any
assistance!