Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2014
    Posts
    1

    Unanswered: Access to Excel: Time Format

    Hello All! This is my first post anywhere. Any help is greatly appreciated.

    I am creating a report solution for an end user, who gets time clock information sent from payroll as text files. He wants the data stored in Access and pulled into Excel Pivot Tables via external data source. Long story short, the time fields do, unfortunately, allow blank values because people sometimes do not punch in and out. Even though I am formatting the columns as "long time" when importing the text files, it is converting the fields to text. I created a query to put a time into the fields if they are blank and then format them as time. However, these calculated fields still come through as text in the Excel Pivot Tables, so I cannot put them in the values section and have them show properly. This is the last leg of this project, so I am going crazy.

    Thanks in advance for your suggestions!

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    It doesnt matter if they are text in the pivot. They will still show the correct time.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •