|
Posted to microsoft.public.excel.misc
|
|
|
New Time Card
See this:
http://www.excelforum.com/showthread...hreadid=523774
Biff
"OSSIE" wrote in
message ...
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:
http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=524580
|