TRY THIS ONE 1 (0=12AM .5=12PM) RIGHT CLICK THE CELL THEN CHANGE FORMAT THEN
TIME. YOU DIVIDE 1 BY 24 TO GET PER HOUR

"garpavco" wrote:

TRYING TO CALCULATE 8 HRS STRAIGHT TIME, IN ADDITION TO ANY HOURS OVER 8
MULTIPLY BY 1 1/2 IN THE SAME CELL