new problem

L

Lise

Ok thanks for all the help on my previous questions but
here's a new one still related to timesheets. My admin
staff is paid hourly/salary 40hrs.

Column c5:c9 is Time In, d5:d9 is Time out. I've
formatted the cells TIME and chose the 1:30 PM example.
When i type in 8 automatically it changes to 12:00 AM. If
I put 8:00 then it changes to 8:00 AM, now in the D cells
i want it to read 4:00 PM. How do i get it to read AM vs
PM?
 
L

Lise

Does that mean it has to be military time? Then to
calculate the difference 8-4 = 8 hours worked. I'd put in
=d5-d4? I want it to figure the hours worked for each day
into j5:j9 and then tally all in for end of week =40hrs
into j10.
 
F

Frank Kabel

Hi
no you can also enter values in the cell like
04:00 AM

you just have to manually enter AM or PM
 
Top