excel-hrs spreadsheet-work 8:15 - 5:30 (how calculate total hrs?)

Discussion in 'Microsoft Excel Worksheet Functions' started by Guest, Mar 14, 2006.

  1. Guest

    Guest Guest

    I am trying to create a database that will show how many hours I work per day
    / per week. I want to put in the time I begin work (example - 8:15) and the
    time I leave (example 5:45) and have it show that I worked 9.5 hours. I've
    tried military time, I've tried formatting time as numbers. Can't get it to
    work with the 60 minutes per hour. Any suggestions on how to do this?
     
    Guest, Mar 14, 2006
    #1
    1. Advertisements

  2. Guest

    Don Guillett Guest

    one way to try where m12 is the start and m13 is the end

    =(M13-M12+IF(M13<M12,0.5))*24

    --
    Don Guillett
    SalesAid Software

    "Harris" <> wrote in message
    news:...
    >I am trying to create a database that will show how many hours I work per
    >day
    > / per week. I want to put in the time I begin work (example - 8:15) and
    > the
    > time I leave (example 5:45) and have it show that I worked 9.5 hours.
    > I've
    > tried military time, I've tried formatting time as numbers. Can't get it
    > to
    > work with the 60 minutes per hour. Any suggestions on how to do this?
     
    Don Guillett, Mar 14, 2006
    #2
    1. Advertisements

  3. Guest

    Irina Guest

    Irina, Mar 14, 2006
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Ron

    Calculate total using hrs by cost per hr

    Ron, Dec 29, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    801
    Norman Harker
    Dec 30, 2003
  2. Guest

    Creat a formula to calculate working hrs according to number of da

    Guest, Jul 29, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    195
    Guest
    Aug 1, 2005
  3. Guest

    calculate count on 2006 total, 2005 total, etc...

    Guest, Sep 28, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    6
    Views:
    301
    Don Guillett
    Sep 28, 2006
  4. Guest

    Calculate time (excluding weekend (48 hrs))

    Guest, Feb 2, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    10
    Views:
    262
    Guest
    Feb 3, 2007
  5. Shawn

    personal hrs is accrued @ 4 hrs./month, need formula to calculate

    Shawn, Jul 22, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    186
    JLatham
    Jul 22, 2008
Loading...

Share This Page