i need to calculate over dayif more than 8 hours give me + with numbers
if less than 8 hours give me - with numbers
so at the end i could calculate exact time

Give me more information - are you collecting "punch in and punch out
times, or just putting in a number for the day

--
KipHartma
-----------------------------------------------------------------------
KipHartman's Profile: http://www.excelforum.com/member.php...fo&userid=3186
View this thread: http://www.excelforum.com/showthread.php?threadid=51631

If the hours worked is in column A, you could put in column B (startin
in B1):

=A1-8

If you need to show the plus sign you could put

=IF(A1-8>0,"+"&(A1-8),A1-8)

but you would not be able to add the numbers with the + in fron
because
they will be stored as text

--
mphell
-----------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...fo&userid=3015
View this thread: http://www.excelforum.com/showthread.php?threadid=51631

http://www.cpearson.com/excel/overtime.htm

--
Kind regards,

Niek Otten

"inour" <(E-Mail Removed)> wrote in message
news:1E009408-1DDD-4608-B260-(E-Mail Removed)...
>i need to calculate over dayif more than 8 hours give me + with numbers
> if less than 8 hours give me - with numbers
> so at the end i could calculate exact time