Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculating Time from Custom date formats

    Hi All,

    I receive the attached data in a report each month in Excel (could be any version).

    The two date columns are Custom Formatted and display Date and Time information.

    I am trying to calculate the time difference between the columns, in minutes, but Excel doesn't seem to be able to calculate from the custom format in the columns.

    Is there any way I can achieve this?

    Thanks for your time.

    Bill
    Attached Files Attached Files

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,640
    Thanks
    115
    Thanked 652 Times in 594 Posts
    Format C column as:
    Date.jpg
    C4=B4-A4 which yields 22:20:00

    HTH,
    Maud

  3. #3
    Star Lounger
    Join Date
    Oct 2012
    Posts
    55
    Thanks
    1
    Thanked 10 Times in 10 Posts
    Hi bnorthby


    Or =B4-A4 & format the cells as [m]

  4. #4
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi All,
    I really appreciate everyone's help. This saved me about 12 hours work!

    This was the solution which worked best for me. Thought the forum would be interested.

    Thanks again.

    Bill

Posting Permissions

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