Hi!

Try this:

=TIME(A1/100,MOD(A1,100)-30,0)

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

=TIME(A1/100,MOD(A1,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=523774