how do i calculate over time per day

I

inour

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
 
K

KipHartman

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

mphell0

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
 
Top