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