Hi
1) Not possible within a format.
2). Start with: http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Regards
Frank Kabel
Frankfurt, Germany

BulaMan wrote:
I did take a look at pearsons sight - might be helpful if I could do
VBA, maybe macros. (1) How about a trick of auto adding 12 hours
withing the formatting? Possible? (2) Can I get a crash course - like
30minutes or less to be able to attempt either macros or VBA for
this? Thank you Frank - BULAMAN