+ Reply to Thread
Results 1 to 3 of 3

Formula to Calculate the Number of Hours Between 2 Dates and Times

  1. 07-11-2014, 02:27 PM #1
    Squint
    Squint is offline
    Registered User
    Join Date
    01-27-2009
    Location
    Owen Sound, Ontario
    MS-Off Ver
    Excel 2016
    Posts
    71

    Formula to Calculate the Number of Hours Between 2 Dates and Times

    I have tried several formulas and nothing is working. I'm not sure what I am doing wrong. I am hoping someone can help me. I am trying to calculate the number of hours between C3 and A3 on the attached spreadsheet. Any help would be much appreciated.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-11-2014, 02:31 PM #2
    johnk13
    johnk13 is offline
    Registered User
    Join Date
    07-11-2014
    Location
    Florida, USA
    MS-Off Ver
    2010
    Posts
    5

    Re: Formula to Calculate the Number of Hours Between 2 Dates and Times

    =(a3-c3)*24
    Reply With QuoteRegister To Reply
  3. 07-11-2014, 03:28 PM #3
    Squint
    Squint is offline
    Registered User
    Join Date
    01-27-2009
    Location
    Owen Sound, Ontario
    MS-Off Ver
    Excel 2016
    Posts
    71

    Re: Formula to Calculate the Number of Hours Between 2 Dates and Times

    Worked perfect

    Thanks so much
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate hours and minutes between two dates/times
    By farrellao in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-17-2014, 07:02 AM
  2. Calculate work hours between two dates/times, incl Sat (variable hours) & excl Pub Hols
    By JReacher in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-02-2013, 10:57 AM
  3. I am trying to calculate the hours betweeen 2 dates and times
    By Lester Wood in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-20-2012, 12:43 PM
  4. Calculate hours between 2 dates/times
    By cords in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-09-2010, 07:25 AM
  5. Calculate 'service hours' between 2 dates/times
    By Sugar Ape in forum Excel General
    Replies: 3
    Last Post: 12-23-2009, 10:44 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1