Results 1 to 6 of 6

Totalling hours from one day to the next

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2005
    Location
    Basingstoke, England
    MS-Off Ver
    2003
    Posts
    86

    Totalling hours from one day to the next

    Hello, I have a problem that I have so far failed to find an answer to. My company works 24/7 and with that some people on nights starting prior to midnight and then finishing after. Of course the "regular" formula works well in calculating between 00:00 onwards but I am getting an error when for instance the person starts at 20:00 and finishes at 04:00. I have tried numerous ways but still the error persists, any ideas? Thank you.
    Last edited by Ducatisto; 10-16-2008 at 02:40 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Available hours calculation in Utilization!!!
    By nandhamnk in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-05-2013, 12:41 AM
  2. Time Sheet - Differential hours?
    By The Chip in forum Excel General
    Replies: 2
    Last Post: 10-01-2008, 05:32 PM
  3. Counting days and hours
    By roddie in forum Excel General
    Replies: 15
    Last Post: 09-11-2008, 05:15 AM
  4. enhanced hours
    By each in forum Excel General
    Replies: 1
    Last Post: 11-04-2006, 07:18 AM
  5. Urgent help reqd. in calculating working hours
    By prabodhkgupta in forum Excel General
    Replies: 0
    Last Post: 10-10-2006, 03:11 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