O
OSSIE
HOW WOULD YOU TAKE THE 1/2 HOUR BREAK TO THE FORMULA BELOW SO IT SHOW
THE EXACT TIME THE PERSON WORKED
=TIME(A1/100,MOD(A1,100),0)
gives 2:11 PM
when A1 has value 141
THE EXACT TIME THE PERSON WORKED
=TIME(A1/100,MOD(A1,100),0)
gives 2:11 PM
when A1 has value 141