software

HOW WOULD YOU TAKE THE 1/2 HOUR BREAK TO THE FORMULA BELOW SO IT SHOWS
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 the
1/2 hour for lunch and it would it give you then the hours worked for
the day

Thankyou for your help the formula below maybe wrong so any help would
be greatly appreciated
=TIME(b1/100,MOD(b2,100),0)
gives 2:11 PM
when A1 has value 1411--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile: www.excelforum.com/member.php...oamp;userid=31638
View this thread: www.excelforum.com/showthread...hreadid=524580See this:

www.excelforum.com/showthread...hreadid=523774

Biff

quot;OSSIEquot; gt; wrote in
message ...
gt;
gt; HOW WOULD YOU TAKE THE 1/2 HOUR BREAK TO THE FORMULA BELOW SO IT SHOWS
gt; THE EXACT TIME THE PERSON WORKED
gt; The Cell is information is
gt; b2 the hours and c2 the hr the shift ends and on d2 woul take out the
gt; 1/2 hour for lunch and it would it give you then the hours worked for
gt; the day
gt;
gt; Thankyou for your help the formula below maybe wrong so any help would
gt; be greatly appreciated
gt; =TIME(b1/100,MOD(b2,100),0)
gt; gives 2:11 PM
gt; when A1 has value 1411
gt;
gt;
gt; --
gt; OSSIE
gt; ------------------------------------------------------------------------
gt; OSSIE's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31638
gt; View this thread: www.excelforum.com/showthread...hreadid=524580
gt;

what i need to know its how many hours the person worked i mean like if
they came in 6 am the ens shift its 2:30 pm and the next cell would
have the answer as 8 hrs or for my night shift they come in at 14:00
and dont leave till 10:30 taht woudl give me again the 8 hrs or
whaterver hours they work hope i explain better thanks--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile: www.excelforum.com/member.php...oamp;userid=31638
View this thread: www.excelforum.com/showthread...hreadid=524580Hi!

Try this:

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

=IF(COUNT(A1:B1)lt;2,quot;quot;,B1-A1 (B1lt;A1)-TIME(0,30,0))

Subtracts 30 minutes for lunch, break, whatever.

Biff

quot;OSSIEquot; gt; wrote in
message ...
gt;
gt; what i need to know its how many hours the person worked i mean like if
gt; they came in 6 am the ens shift its 2:30 pm and the next cell would
gt; have the answer as 8 hrs or for my night shift they come in at 14:00
gt; and dont leave till 10:30 taht woudl give me again the 8 hrs or
gt; whaterver hours they work hope i explain better thanks
gt;
gt;
gt; --
gt; OSSIE
gt; ------------------------------------------------------------------------
gt; OSSIE's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31638
gt; View this thread: www.excelforum.com/showthread...hreadid=524580
gt;