Results 1 to 5 of 5

Excel 2007 : Converting decimal to time

Threaded View

  1. #1
    Registered User
    Join Date
    10-10-2007
    Posts
    18

    Converting decimal to time

    Hi all, I was hoping you could help me with a small problem. I'm tasked with taking a plain decimal number, say 1700, and converting it into it's 12-hour time equivalent (5:00 PM). The problem I'm running into is I am NOT allowed to use a colon for the decimal number whatsoever; it MUST be a standard generic number. Any help would be appreciated. Thanks!
    Last edited by NBVC; 11-23-2011 at 05:46 PM.

Thread Information

Users Browsing this Thread

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

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