Results 1 to 21 of 21

How to count hours

Threaded View

  1. #10
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    Nightmare time sheet

    As always, the more set in their ways a person is, the harder it is to write code which will be compatible with their system.

    This will work if and ONLY if you type in times in the exact format which are given in the examples. And, as SHG stated, this one will also only work on hours in the same day.

    That,
    and it's 24 lines of code.
    Been a little slow in the office here today :P

    I left the steps which I took at the bottom, so you can go over the progression of the nightmare of gobbledeegook which is the final result.

    Lemme know what you think, I'm still kinda new to this, so I'm mashing what I know with examples I find in order to make stuff work the way I want it to.
    Attached Files Attached Files
    Last edited by mewingkitty; 09-29-2008 at 06:52 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count numbers of times within hours
    By dreicer_Jarr in forum Excel General
    Replies: 3
    Last Post: 06-24-2015, 09:49 PM
  2. Counting days and hours
    By roddie in forum Excel General
    Replies: 15
    Last Post: 09-11-2008, 05:15 AM
  3. count hours past midnight
    By cojast in forum Excel General
    Replies: 3
    Last Post: 07-01-2008, 03:53 PM
  4. Count the hours of each day for the month
    By kdraper in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-20-2007, 06:42 AM
  5. enhanced hours
    By each in forum Excel General
    Replies: 1
    Last Post: 11-04-2006, 07:18 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1