+ Reply to Thread
Results 1 to 3 of 3

Convert time to numeric value

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    Lubbock, Texas
    MS-Off Ver
    Excel 2003
    Posts
    18

    Convert time to numeric value

    I am having issues in creating a new schedule document for work. I insert the associates name, when they arrive and when they leave. I would like for the spreadsheet to not only determine the number of hours that they work but also the length of break that they will receive.

    If the associate works more than or equal to 5 hours they receive a 30 minute break.
    If the associate works less than 5 hours they receive only a 15 minute break.

    I have attached an example to better show what I am working with and the formula that I am currently trying to use.
    Attached Files Attached Files

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Convert time to numeric value

    Try this in F4

    =IF(E4>=0.208333333333333,30,15)

    B
    C
    D
    E
    F
    1
    Schedule
    2
    3
    NAME
    Time In
    Time Out
    Shift length
    Break
    4
    Associate A
    10:00 AM
    5:00 PM
    7:00
    30
    5
    Associate B
    10:00 AM
    3:00 PM
    5:00
    30
    6
    Associate C
    2:00 PM
    6:00 PM
    4:00
    15
    7
    Associate D
    12:00 PM
    6:00 PM
    6:00
    30
    8
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Convert time to numeric value

    You're welcome and thanks for the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Convert alpha-numeric to numeric
    By michael mac in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-12-2008, 04:13 PM
  2. [SOLVED] Can I convert numeric 0510 to time 05:10 by custom cell format?
    By Rita_H in forum Excel General
    Replies: 4
    Last Post: 07-27-2006, 08:45 AM
  3. Convert numeric to time
    By Corby in forum Excel General
    Replies: 2
    Last Post: 02-28-2006, 11:55 AM
  4. Replies: 4
    Last Post: 02-06-2006, 03:05 AM
  5. [SOLVED] How do convert time into numeric
    By Charles in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-01-2005, 04:35 AM

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