+ Reply to Thread
Results 1 to 3 of 3

Excel formula for hours calculator?

  1. #1
    Registered User
    Join Date
    08-03-2016
    Location
    Phoenixville
    MS-Off Ver
    MS Office 2013
    Posts
    14

    Excel formula for hours calculator?

    Making a timesheet excel file:

    Column A is start time, Column B is end time, Column C is the difference in times. My problem is taking standard hour values (10:00 AM, 9:30 PM for example) and subtracting them from other hour values to get a non-hour value.

    For example, Col. A = 9:30, Col. B = 11:00

    How do I get Col. C to output 1.5 as the value? Will there be issues when going from AM to PM?

    Thank you!

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Excel formula for hours calculator?

    Is this what you want...

    Data Range
    A
    B
    C
    1
    Start
    End
    Total
    2
    9:30 PM
    11:00 PM
    1.5
    3
    8:30 PM
    12:30 AM
    4
    4
    10:00 PM
    6:15 AM
    8.25


    This formula entered in C2:

    =MOD(B2-A2,1)*24

    Format as General or Number and copy down as needed.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    08-17-2012
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: Excel formula for hours calculator?

    Hi there, when you do subtract the two times Excel will return the difference in days, so you have to multiply the result by 24 hours.

    Thy this:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Formula Calculator
    By dankusko in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-02-2015, 05:45 AM
  2. Day into Hours into Minutes Calculator Spreadsheet
    By jeph_oliver in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 02-27-2015, 03:13 PM
  3. Replies: 4
    Last Post: 01-09-2015, 12:27 PM
  4. Staff hours calculator minus relevant breaks
    By mjamil123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-15-2013, 01:35 PM
  5. Hours Worked Calculator
    By sammer021486 in forum Excel General
    Replies: 2
    Last Post: 08-08-2008, 02:41 AM
  6. Working Hours Forcast Calculator
    By Mechie01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2007, 02:39 PM
  7. Integrated calculator in excel 07 instead of separate calculator
    By Wayne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2006, 11:20 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1