Results 1 to 4 of 4

Time Calculation

This is a discussion on Time Calculation within the Excel Questions forums, part of the Question Forums category; Hello, I want to end up with a decimal number for inbetween two times. I need a formula if its ...

  1. #1
    New Member
    Join Date
    Jun 2002
    Posts
    15

    Default

    Hello,

    I want to end up with a decimal number for inbetween two times. I need a formula if its possible for this:

    B4 = Start Time
    C4 = End Time
    D4 = =TEXT(C4-B4,"h:mm") For the calculation

    Then I get the amount in time value. This is good but I need a formula that will take this time and divide by 60 so I can get the time in decimal form.

    Thanks.



  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    61,998

    Default

    On 2002-07-22 12:06, sondriven wrote:
    Hello,

    I want to end up with a decimal number for inbetween two times. I need a formula if its possible for this:

    B4 = Start Time
    C4 = End Time
    D4 = =TEXT(C4-B4,"h:mm") For the calculation

    Then I get the amount in time value. This is good but I need a formula that will take this time and divide by 60 so I can get the time in decimal form.

    Thanks.
    Why not just use in D4:

    =(C4-B4)*24

    which you format as General?

  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582

    Default

    Hi Sondriven

    You might find this link helpful

    http://www.ozgrid.com/Excel/ExcelDateandTimes.htm


    Details how Excel sees Dates and Times

  4. #4
    New Member
    Join Date
    Jun 2002
    Posts
    15

    Default

    Thank you!

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