Results 1 to 3 of 3

Thread: Calculate the Hours

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-27-2013, 12:53 PM #2
    Kevin@Radstock
    Kevin@Radstock is offline
    Junior Member
    Join Date
    Dec 2012
    Posts
    16
    Rep Power
    0
    Hi leopaulc

    The first thing is to convert all the text numbers to real numbers. Select a blank cell, copy > Select the data C2:AD27 > Paste Special > Tick the Add > Click OK > format cells as hh:mm or [h]:mm.

    Then you can total the rows, see the attached, column AE.

    Kevin
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Macro To Calculate Percentage Allocation
    By Howardc in forum Excel Help
    Replies: 3
    Last Post: 06-01-2013, 01:59 PM
  2. calculate sum of three numbers where the answer should be zero
    By ashu1990 in forum Excel Help
    Replies: 1
    Last Post: 04-24-2013, 04:34 PM
  3. Calculate Minimum Value Based On Percentage When Denominator Is Different
    By lokvan in forum Excel Help
    Replies: 2
    Last Post: 03-31-2013, 01:54 PM
  4. Hours Calculation between two times
    By excel_learner in forum Excel Help
    Replies: 3
    Last Post: 11-21-2012, 05:04 PM
  5. Convert 24 hours to 48 hours in excel
    By dhiraj.ch185 in forum Excel Help
    Replies: 2
    Last Post: 11-15-2011, 09:02 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
  •  

Forum Rules