Representing times in excel without dates

B

Bugaloo Bill

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!
 
E

ehntd

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.
 
Top