Results 1 to 16 of 16

Date and Time display in Pivot Table

Threaded View

  1. #1
    Registered User
    Join Date
    06-14-2010
    Location
    Detroit, MI
    MS-Off Ver
    Excel 2003
    Posts
    84

    Date and Time display in Pivot Table

    On my data sheet I have the following format:

    Company Name Scheduled Time Actual Time Number variance
    Joe Doe 06/01/10 08:15 AM 06/01/10 08:15 AM 0.010416667
    John Brown 06/03/10 05:12 AM 06/03/10 05:12 AM -0.033333333
    Joe Doe 06/08/10 12:55 PM 06/08/10 12:55 PM 1.288194444
    ... ... ...

    In my pivot table, I want to display the Avg number variance for each company in the following time format:

    0 hour(s) 15 min(s) Late/Early/Ontime

    Which is this formula:
    =IF('Num Var' =0,"On Time",TEXT(ABS('Num Var' ),"[h]"" hour(s) ""m"" min(s) """)&IF('Num Var' <0," Early","Late"))

    but when I enter that into calculate field formula area, it gives me an error #VALUE
    Last edited by ybu1106; 07-19-2010 at 02:16 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