+ Reply to Thread
Results 1 to 2 of 2

[SOLVED] Getting a total of hours & mins worked per week

  1. #1
    big_weegie
    Guest

    [SOLVED] Getting a total of hours & mins worked per week

    I am trying to make a spreadsheet of the daily hours worked and a total of
    the weekly hours but i am not having any luck, at the moment I have the
    following

    H3 08:33, H4 08:01, H5 07:23, H6 08:15, H7 08:15, when i type =sum(h3:h7) i
    get 16:27 instead of 40:27 i would appreciate any advice

    thanks

  2. #2
    JE McGimpsey
    Guest

    Re: Getting a total of hours & mins worked per week

    XL stores times as fractional days (e.g., 3:00 = 0.125). The default
    time display "rolls over" every 24 hours. To keep that from happening,
    use brackets in your format:

    Format/Cells/Number/Custom [h]:mm


    In article <[email protected]>,
    "big_weegie" <[email protected]> wrote:

    > I am trying to make a spreadsheet of the daily hours worked and a total of
    > the weekly hours but i am not having any luck, at the moment I have the
    > following
    >
    > H3 08:33, H4 08:01, H5 07:23, H6 08:15, H7 08:15, when i type =sum(h3:h7) i
    > get 16:27 instead of 40:27 i would appreciate any advice
    >
    > thanks


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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