+ Reply to Thread
Results 1 to 3 of 3

Need duration of Hours

  1. 07-26-2016, 07:59 AM #1
    Balasubramanian_2018
    Balasubramanian_2018 is offline
    Registered User
    Join Date
    07-25-2016
    Location
    Indian,Tamilnadu
    MS-Off Ver
    2010
    Posts
    2

    Need duration of Hours

    Created Date
    2016-07-10 01:54:49:am

    Today Date
    2016-07-26 13:54:49:PM


    Need duration of Hours ( formula should calculate the hours based on the dates)
    Reply With QuoteRegister To Reply
  2. 07-26-2016, 09:32 AM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need duration of Hours

    how about a1-a2 and format the cell to hours?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 07-26-2016, 09:49 AM #3
    Greg M
    Greg M is online now
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Need duration of Hours

    Hi there,

    See if the attached workbook gets you moving in the right direction.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M
    Attached Files Attached Files
    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. Calculation of Time duration in hours from 24hours input data
    By maxonline in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-04-2016, 10:51 AM
  2. Excel macro to allocate a list of values with different duration to hours of the year
    By VerMox in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-28-2015, 09:40 AM
  3. [SOLVED] Formula: To calculate duration between two times, if duration is over 6hours subtract 30mi
    By MattBarnes7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2013, 03:22 PM
  4. Count # Sick Day Occurrences based on dates and the Duration of each occurrence in hours
    By Elizabeth Bancroft in forum Excel General
    Replies: 12
    Last Post: 07-25-2012, 10:13 PM
  5. Calculating hours worked by duration - Pivot Tables
    By Daniel Black in forum Excel General
    Replies: 2
    Last Post: 07-08-2009, 07:29 AM
  6. calculate duration of hours
    By winco32 in forum Excel General
    Replies: 2
    Last Post: 11-09-2008, 06:43 AM
  7. Duration of time for two dates in days, hours and minutes
    By sgrimm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2006, 09:39 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