display time in 12 hour format

J

jatman

i am working on a schedule for staff (office 2007) and i only have one issue
left. can i enter the time a 24 hour format and have it display in a 12 hour
format. not everyone understands the 24 hour clock, or they just do not wan
to learn it.

ex.

start time in A1 is 8:00 (8:00 AM,) it shows as 8:00
end time in B1 is 16:00 (4:00 PM,) but it shows just 4:00

i have the calculations on totalling the time and everything else, just need
to show the time in the 12 hour format.

thank you,

jat
 
K

Kassie

in stead of formatting your cell as hh:mm, go up two options, to hh:mmAM/PM,
and that should do the trick
 

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

Top