+ Reply to Thread
Results 1 to 3 of 3

change date format to absolute number

  1. #1
    Registered User
    Join Date
    06-05-2014
    Posts
    28

    change date format to absolute number

    i have a column with times of day and need a helper column to show the starting hour. for example, column a1 - 9:53am would like b1 to show 9am or 9. i tried customizing the date format to 'h' only, but when I pivot the table it still shows several 9's

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: change date format to absolute number

    Please use a supporting column B & in B1 use =HOUR(A1) & it will show absolute number

  3. #3
    Registered User
    Join Date
    06-05-2014
    Posts
    28

    Re: change date format to absolute number

    thanks that was what i needed

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Convert text to number and change date format in a macro.
    By Zimmerray1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-15-2014, 07:04 PM
  2. Change Format of Cell into a Number (it thinks it's a date)
    By nkitchen31 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-15-2013, 11:19 PM
  3. Change backwards number format to date format
    By vickie10200 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-10-2013, 01:32 PM
  4. Replies: 1
    Last Post: 11-29-2010, 12:10 PM
  5. Formulae to change text formatted date to number format
    By shekar goud in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-11-2010, 01:57 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