Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/time code, both, accesible by hotkey?
I've been using the ^+; a lot in my spreadsheets and by using a custom
format in the date cells. This has worked very well. But is there a way to have both the current date _and_ time keyed in with _one_ hotkey rather than using the ^+; for the date and then in another cell, CTRL+SHIFT+: for the time? It would be nice to save the user time/aggravation by just using one cell and one hotkey. Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/time code, both, accesible by hotkey?
Hold Ctrl, hit the ; key, and then before releasing Ctrl, hit the :
(Shift-;) as well. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "StargateFanFromWork" wrote in message ... I've been using the ^+; a lot in my spreadsheets and by using a custom format in the date cells. This has worked very well. But is there a way to have both the current date _and_ time keyed in with _one_ hotkey rather than using the ^+; for the date and then in another cell, CTRL+SHIFT+: for the time? It would be nice to save the user time/aggravation by just using one cell and one hotkey. Thank you! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/time code, both, accesible by hotkey?
"Bob Phillips" wrote in message
... Hold Ctrl, hit the ; key, and then before releasing Ctrl, hit the : (Shift-;) as well. -- HTH That sure did help, thank you! Very clever. However, a formatting issue: no matter what the cell formatting is, my custom shown here within quotes - "yyyy.mm.dd.ddd; hh:mm" - or even any of the other standard formats, I always get a display like this: 6/29/20042:46 PM There is no space in between the date and time nor is any format adhered to. What am I doing wrong in this aspect? Thank you! Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "StargateFanFromWork" wrote in message ... I've been using the ^+; a lot in my spreadsheets and by using a custom format in the date cells. This has worked very well. But is there a way to have both the current date _and_ time keyed in with _one_ hotkey rather than using the ^+; for the date and then in another cell, CTRL+SHIFT+: for the time? It would be nice to save the user time/aggravation by just using one cell and one hotkey. Thank you! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/time code, both, accesible by hotkey?
Most odd. When I tried it before posting, I could swear that Excel input a
space (very clever I thought). Now it doesn't, so I have to manually insert a space, and I can then format it as I want. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "StargateFanFromWork" wrote in message ... "Bob Phillips" wrote in message ... Hold Ctrl, hit the ; key, and then before releasing Ctrl, hit the : (Shift-;) as well. -- HTH That sure did help, thank you! Very clever. However, a formatting issue: no matter what the cell formatting is, my custom shown here within quotes - "yyyy.mm.dd.ddd; hh:mm" - or even any of the other standard formats, I always get a display like this: 6/29/20042:46 PM There is no space in between the date and time nor is any format adhered to. What am I doing wrong in this aspect? Thank you! Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "StargateFanFromWork" wrote in message ... I've been using the ^+; a lot in my spreadsheets and by using a custom format in the date cells. This has worked very well. But is there a way to have both the current date _and_ time keyed in with _one_ hotkey rather than using the ^+; for the date and then in another cell, CTRL+SHIFT+: for the time? It would be nice to save the user time/aggravation by just using one cell and one hotkey. Thank you! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/time code, both, accesible by hotkey?
"Bob Phillips" wrote in message
... Most odd. When I tried it before posting, I could swear that Excel input a space (very clever I thought). Now it doesn't, so I have to manually insert a space, and I can then format it as I want. Yup, it doesn't work for me. If I add a space, it knocks off the time and just leaves the date <chuckle. Oh boy, what a challenging day this has been ... I've given up on this. I just put in date and time cells. It'll do. Maybe once I get better at this, I can figure out something easier. Thank you very much! <g -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "StargateFanFromWork" wrote in message ... "Bob Phillips" wrote in message ... Hold Ctrl, hit the ; key, and then before releasing Ctrl, hit the : (Shift-;) as well. -- HTH That sure did help, thank you! Very clever. However, a formatting issue: no matter what the cell formatting is, my custom shown here within quotes - "yyyy.mm.dd.ddd; hh:mm" - or even any of the other standard formats, I always get a display like this: 6/29/20042:46 PM There is no space in between the date and time nor is any format adhered to. What am I doing wrong in this aspect? Thank you! Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "StargateFanFromWork" wrote in message ... I've been using the ^+; a lot in my spreadsheets and by using a custom format in the date cells. This has worked very well. But is there a way to have both the current date _and_ time keyed in with _one_ hotkey rather than using the ^+; for the date and then in another cell, CTRL+SHIFT+: for the time? It would be nice to save the user time/aggravation by just using one cell and one hotkey. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting text format of time/date into Excel time/date for subtr | Excel Worksheet Functions | |||
Static Date and Time code problem | Excel Discussion (Misc queries) | |||
MS Office Excel Date-Time Code | Excel Discussion (Misc queries) | |||
DATEDIF Function Should Be More Accesible | Excel Discussion (Misc queries) | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions |