#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
darkbearpooh1
 
Posts: n/a
Default time


any ideas to enter time faster for instance if i am entering 3:00
(meaning 3am or pm) is there a way to enter it faster than hiting the
shift+(:) for time. is it possible to make the (:) a one button
function?


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=512757

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
darkbearpooh1
 
Posts: n/a
Default time


i applologise for the smilie face but you know i mean the colon button


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=512757

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
darkbearpooh1
 
Posts: n/a
Default time


i thought about caps lock to see if it reversed the key stroke but that
didn't work


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=512757

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Entering Times Denise Excel Discussion (Misc queries) 9 November 15th 05 04:57 PM
time differences in a column 68magnolia71 Excel Worksheet Functions 3 May 9th 05 09:46 PM
Accumulate weekly time to total time in Excel. delve Excel Discussion (Misc queries) 0 May 4th 05 08:14 PM
Time Sheet Calculation Help Needed! sax30 Excel Worksheet Functions 2 April 26th 05 08:08 PM
time formatting and time categorizing (vlookup or data validation) MarianneR Excel Worksheet Functions 4 November 18th 04 03:24 PM


All times are GMT +1. The time now is 10:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"