Representing times in excel without dates

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

Guest

Excel experts I need your help!! I am using Office XP excel and am trying to
represent time in the format: AM/PM without seconds. When I put in the time
[I have the cell number format set to time/"1:30PM"/Locale is English (United
States)], it comes up with the date preceding the time. I have tried varying
settings of time but they all come up with the date. So if I try to put in
1:00PM it would represent this as a date and leave the rest of the time as
12am. I am doing a time sheet that subtracts the hours from between two times
and then adds the differences up. I want it to be user friendly so that the
times are easy to put in without dates coming up!
 
Format the cells as personalized. Do a h:mm AM/PM and this will give
you the correct time. For PM you need to put 13 or 17 for example, but
once you enter it the conversion is done automatically.
 
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

Date Dilemna 3
Date Time formatting problem 7
Separate AM/PM from time. 2
Entering a time into excel 10
Working With Dates in Excel 2
Sumproduct with date and time? 1
default time to PM after 12:00 pm 4
Calculate times between dates and times in Excel 1

Back
Top