Date and Time Formula
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Date and Time Formula

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    G'Day Excel Gurus...

    I'm trying to set up an excel spreadsheet which allows me to calculate the number of minutes between 2 Dates and times.

    i.e minutes between 1/03/2002 15:00 and 2/03/2002 15:30

    Any Help would be appreciated !


  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You may want to do a search before asking questions; this is a fairly common one.

    If A1 contains 1/3/2002 15:00
    If B1 contains 2/3/2002 15:30

    Format C1 as number with 2 decimals.
    Put =(B1-A1)*60


    ~Anne Troy

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for your help...

    Believe me I've searched EVERYWHERE for an answer to this.

    Tried your formula and formated the cell as you mentioned, but it does not do the calculation. Am I missing something ?

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think you should multiply by 24*60 to get minutes. The difference is calculated in fractions of a day.

    Russell

  5. #5
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi edq


    If you time and date cells are A1 and A2 you could use:

    =MAX(A1:B1)-MIN(A1:B1)

    and Custom format the cell as [m]

    Or to actually get the real number (as apposed to format) try:

    =TEXT(MAX(A1:B1)-MIN(A1:B1),"[m]")*1



  6. #6
    New Member
    Join Date
    Feb 2002
    Location
    Jeddah,Saudi Arabia
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Dreamboat's formula is right, you have to multiply by 24 for the difference in day and I wish you will get the answer right.

    I use C1=(B1-A1)*60*24

    HTH
    ernie

  7. #7
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks to All for your help on this one...

    I've got it working the way I want now

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com