Results 1 to 16 of 16

Enter Date and Time quick way

Threaded View

  1. #13
    Registered User
    Join Date
    09-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    13

    Re: Enter Date and Time quick way

    Thanks very much. Now I am not able to calculate the number of hours worked from Shift Start and Shift End fields. If the Shift Start is 5:25 PM and Shift End is 4:15 AM, then I should be able to get 8.83 Hrs or 8 Hrs 50 Mins so that I can calculate the amount per hour.

    Is there anyway I can change the code so that when I type in Shift Start, I should get PM only? I tend to type 5 instead of 17 as it is on paper but typing 5 gives me AM. As I quickly type, I cannot think and type whatever is on the paper.
    Last edited by kryptic; 09-17-2013 at 07:09 AM. Reason: added extra line

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] automatically enter time & date
    By MUDDER460 in forum Excel General
    Replies: 18
    Last Post: 12-07-2012, 06:49 AM
  2. Macro to automatically enter time & date
    By mellis123 in forum Excel General
    Replies: 6
    Last Post: 06-16-2012, 06:44 AM
  3. Enter date and time
    By akhtar151 in forum Excel General
    Replies: 5
    Last Post: 10-13-2007, 11:25 AM
  4. [SOLVED] Any quick key for entering Current Date and Time?
    By Philip in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2006, 12:25 PM
  5. Any quick key to insert current Date and Time?
    By Philip in forum Excel General
    Replies: 2
    Last Post: 01-12-2006, 12:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1