New Time Card

[OSSIE]

HOW WOULD YOU TAKE THE 1/2 HOUR BREAK TO THE FORMULA BELOW SO IT SHOW
THE EXACT TIME THE PERSON WORKED
The Cell is information is
b2 the hours and c2 the hr the shift ends and on d2 woul take out th
1/2 hour for lunch and it would it give you then the hours worked fo
the day

Thankyou for your help the formula below maybe wrong so any help woul
be greatly appreciated
=TIME(b1/100,MOD(b2,100),0)
gives 2:11 PM
when A1 has value 141

 

[Biff]

See this:

http://www.excelforum.com/showthread.php?threadid=523774

Biff

 

[OSSIE]

what i need to know its how many hours the person worked i mean like i
they came in 6 am the ens shift its 2:30 pm and the next cell woul
have the answer as 8 hrs or for my night shift they come in at 14:0
and dont leave till 10:30 taht woudl give me again the 8 hrs o
whaterver hours they work hope i explain better thank

 

[Biff]

Hi!

Try this:

A1 = 6:00 AM
B1 = 2:30 PM

=IF(COUNT(A1:B1)<2,"",B1-A1+(B1<A1)-TIME(0,30,0))

Subtracts 30 minutes for lunch, break, whatever.

Biff