+ Reply to Thread
Results 1 to 2 of 2

evaluating one of two items in a single cell

  1. #1
    Registered User
    Join Date
    01-06-2010
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    evaluating one of two items in a single cell

    Hi all,

    I am creating a spreadsheet to log both regular and overtime hours on a job for each employee on each day. Ultimately my question is this:

    If I were to enter reg. and OT hours in each cell (row-employee, column-date), as numbers separated by a comma or semi-colon...could I have excel evaluate only one of the two numbers in the cell for the entire spread sheet if say, I wanted to sum the total number of regular hours and total number of overtime hours on the job?

    My thoughts were if I was able to do that I could just write a short and sweet sum function to sum regular and OT hours separately.

    EX:
    01/06/2010
    John Doe 8,3

    Thanks!
    Matt

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Re: evaluating one of two items in a single cell

    You could by using MID, RIGHT and VALUE functions.

    Sooner or later you will get into trouble. Why not use 'normal' time/Date values as these will give you the totals very easily?

    You might want to read these:
    http://www.excelforum.com/excel-2007...lculation.html
    http://www.excelforum.com/excel-2007...lculation.html
    Last edited by rwgrietveld; 01-06-2010 at 10:12 AM.
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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