how do I change a cell permanently to PM from AM?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to do this permanently to the template, so that I have
timesheets that I don't hav eto change everytime I input my time data. Thx
 
The question is not clear so here are some suggestions

B1: =A1-0.5
A1: 11:00 PM ---> B1: 11:00 AM

=IF(A1>0.5,A1-0.5,A1)

Menu:Data>Validation... Allow:Time, Data:Less then or Equal to, End
time: 12:00


Hope it helped
Ola Sandström
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Catagorise AM or PM 7
Separate AM/PM from time. 2
AM / PM Cells 3
AM/PM Format 6
Input Time in AM/PM 3
how do i permanently change the page setup in excel? 1
make filter permanent 2
Copy a Formula from a Column to a Row 2

Back
Top