Results 1 to 5 of 5

Converting AM PM into 24hr

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-26-2018
    Location
    London, England
    MS-Off Ver
    365
    Posts
    312

    Converting AM PM into 24hr

    Hi All,

    I've having a nightmare trying to convert AM PM times into 24hr, I keep receiving VALUE errors (Column C)

    Column D is the result I'm trying to achieve

    Thanks

    Mdn
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. recognising 24hr time
    By dodger999 in forum Excel General
    Replies: 2
    Last Post: 04-23-2011, 06:21 PM
  2. 24Hr times
    By Sandpit in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-24-2011, 03:37 PM
  3. time 24hr
    By ianm34 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-13-2010, 07:34 PM
  4. Converting a time value to 24hr Clock
    By Sugar Ape in forum Excel General
    Replies: 6
    Last Post: 10-09-2009, 05:26 AM
  5. 24hr date error
    By ukphoenix in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-15-2007, 07:57 AM
  6. [SOLVED] 24hr moving average
    By Nadia in forum Excel General
    Replies: 1
    Last Post: 11-28-2005, 06:35 PM
  7. code for 24hr clock?
    By Skullcramp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2005, 08:45 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1