+ Reply to Thread
Results 1 to 3 of 3

Entering time into spreadsheets

  1. 12-27-2019, 09:49 AM #1
    wfd086
    wfd086 is offline
    Registered User
    Join Date
    12-21-2019
    Location
    Rhode Island
    MS-Off Ver
    Office 365
    Posts
    2

    Entering time into spreadsheets

    I have a spreadsheet where I have to enter the time in 24 hour time. When I enter the time right now I have to format it with a colon between hours and minutes. Is there a way that I can set it up so that all I have to do is enter the 4 numbers. It is quite a pain in the butt having to enter it with the colon. Thanks in advance.
    Reply With QuoteRegister To Reply
  2. 12-27-2019, 10:02 AM #2
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Entering time into spreadsheets

    As I understand, you would require VBA to manipulate the number you just entered. Do you want to use VBA?

    What are you entering and what do you want to see?
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  3. 12-27-2019, 10:15 AM #3
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Entering time into spreadsheets

    Hi wfd,

    Does this article help?

    https://www.pcmag.com/article2/0,2817,2316755,00.asp
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. entering the time in each cell
    By toddp2 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 10-23-2016, 02:49 PM
  2. entering a formula that incorporates calculated reference to other spreadsheets
    By whalewatcher in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-06-2013, 05:08 AM
  3. [SOLVED] How to subtract time without entering colon and retain time format?
    By blmholland in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2013, 10:36 PM
  4. Entering time in spread sheet and it reflects as military time.
    By swade730 in forum Excel General
    Replies: 2
    Last Post: 03-18-2013, 10:12 PM
  5. Entering Data in master spreadsheet ---> individual spreadsheets
    By amanda41590 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-21-2012, 03:58 PM
  6. display end time automatically upon entering start time and time usage
    By stoey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-19-2008, 06:16 PM
  7. Having trouble keeping entering time on a time sheet
    By cranetech in forum Excel General
    Replies: 1
    Last Post: 06-23-2008, 02:16 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1