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

=TIME(A1/100,MOD(A1,100),0)
gives 2:11 PM
when A1 has value 141

 

[Biff]

Hi!

Try this:

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

Biff