Jerry - thanks for the reply

The first cell displays 7:15 in number or general format. I guess this
means that excel thinks it's text?

surely i don't want it to say 7:15:00 AM because that suggests the
time...? dave spent 7 hours and 15 minutes on site on the first day,
it's a cumulative value not a signing in time.

sounds like i need to change the format to make excel recognise the
values as numbers, more specifically cumulative times of hours and
minutes in order to be able to add them. There must be a way to do
this without changing each cell manually - theres 4000+ lines of data,
changing each cell individually isn't an option!

Tried changing the column to format [hh]:mm and no difference....

Regards, S


--
Bugjam1999
------------------------------------------------------------------------
Bugjam1999's Profile: http://www.excelforum.com/member.php...o&userid=26178
View this thread: http://www.excelforum.com/showthread...hreadid=394908