Chip Pearson shows how you can do that he
'Date And Time Entry'
(
http://www.cpearson.com/excel/DateTimeEntry.htm)
Hope this helps.
Pete
Pee;294417 Wrote:
Hi, I've got 2007 on my pc and I'm trying to set up a timesheet. As I'm
to
lazy to keep entering the ":" all the time, i was wondering if someone
knew
how to change 1530 to 15:30 etc in the active cell for all cells G5 to
I19
on all 5 sheets in my workbook!!!
I think this has something to do with vba or macros and i've never used
them
before.
If anyone can help me, I'd be very grateful.
Thanks
Pete
--
Pete_UK
------------------------------------------------------------------------
Pete_UK's Profile:
http://www.thecodecage.com/forumz/member.php?userid=205
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=82294