Results 1 to 5 of 5

Total hour calculation

Threaded View

thisara Total hour calculation 08-31-2014, 11:38 PM
Vikas_Gautam Re: Total hour calculation 08-31-2014, 11:59 PM
thisara Re: Total hour calculation 09-01-2014, 12:52 AM
samba_ravi Re: Total hour calculation 09-01-2014, 01:05 AM
thisara Re: Total hour calculation 09-01-2014, 02:43 AM
  1. #1
    Registered User
    Join Date
    11-20-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    12

    Total hour calculation

    Here with I have attached excel worksheet. I need to calculate daily work hours and at the end calculate total hours.

    Thank You

    Status Date/Time

    START JOB 28/08/2014 / 15:53
    END JOB 28/08/2014 / 16:53

    START JOB 27/08/2014 / 09:18
    END JOB 27/08/2014 / 09:29
    START JOB 27/08/2014 / 13:15
    END JOB 27/08/2014 / 15:18

    START JOB 26/08/2014 / 10:31
    END JOB 26/08/2014 / 12:33
    START JOB 26/08/2014 / 13:20
    END JOB 26/08/2014 / 17:14

    START JOB 25/08/2014 / 10:41
    END JOB 25/08/2014 / 17:36

    START JOB 19/08/2014 / 09:05
    END JOB 19/08/2014 / 12:30
    START JOB 19/08/2014 / 12:58
    END JOB 19/08/2014 / 14:25

    START JOB 18/08/2014 / 11:17
    END JOB 18/08/2014 / 12:48
    START JOB 18/08/2014 / 13:14
    END JOB 18/08/2014 / 17:28

    START JOB 13/08/2014 / 09:03
    END JOB 13/08/2014 / 12:28
    START JOB 13/08/2014 / 12:59
    END JOB 13/08/2014 / 17:09

    START JOB 12/08/2014 / 09:03
    END JOB 12/08/2014 / 12:33
    START JOB 12/08/2014 / 12:59
    END JOB 12/08/2014 / 17:09

    START JOB 11/08/2014 / 09:03
    END JOB 11/08/2014 / 12:30
    START JOB 11/08/2014 / 12:59
    END JOB 11/08/2014 / 17:09

    START JOB 08/08/2014 / 09:14
    END JOB 08/08/2014 / 12:31
    START JOB 08/08/2014 / 12:57
    END JOB 08/08/2014 / 14:43

    START JOB 07/08/2014 / 09:10
    END JOB 07/08/2014 / 12:31
    START JOB 07/08/2014 / 12:58
    END JOB 07/08/2014 / 13:17

    START JOB 06/08/2014 / 09:06
    END JOB 06/08/2014 / 12:30
    START JOB 06/08/2014 / 12:59
    END JOB 06/08/2014 / 17:04

    START JOB 05/08/2014 / 09:04
    END JOB 05/08/2014 / 12:32
    START JOB 05/08/2014 / 13:06
    END JOB 05/08/2014 / 13:09

    START JOB 04/08/2014 / 09:43
    START JOB 04/08/2014 / 09:50
    END JOB 04/08/2014 / 09:50
    END JOB 04/08/2014 / 12:30
    START JOB 04/08/2014 / 13:06
    END JOB 04/08/2014 / 17:18

    START JOB 01/08/2014 / 09:28
    PAUSE JOB 01/08/2014 / 10:38
    Attached Files Attached Files
    Last edited by thisara; 09-01-2014 at 12:54 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hour Calculation Help!!!!!!
    By MinieMe209 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-25-2014, 08:23 PM
  2. [SOLVED] Rate Calculation - per hour
    By ganeshinscribe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2013, 06:20 AM
  3. Calculation of average and the max CPU for the hour
    By zahedreza.k in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-01-2013, 01:12 PM
  4. SLA non-business hour calculation
    By tirthasarathi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2010, 04:50 PM
  5. [SOLVED] calculation of pounds per hour
    By george in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-02-2005, 02:05 PM

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