+ Reply to Thread
Results 1 to 2 of 2

Converitng Numbers into times for costings issue

  1. #1
    Registered User
    Join Date
    02-28-2008
    Posts
    1

    Converitng Numbers into times for costings issue

    Hi,
    My name is Scott, and i am working on a scheduling system that costs itsef automatically. The aim is the when I draw up schedules for employees, i input the hour they start and the hour they finish. i.e.
    A B
    ******************************
    1 * M o n d a y *
    ******************************
    2 *Start * Finish *
    ******************************
    3 Employee A * 0900 * 1300 *
    ******************************
    From the start and finish times I work out the number of hours worked per day (minus 1 hour for lunch if working over 8 hours). Using the following equation =IF(B3-A3>800,B3-A3-100,B3-A3). (I have using numbering instead of time as I am not sure how to convert time in numbers for costings). My problem is converting quarters in time to quarters in numbers for costings. ie schedules 0915 - 1330, needs to be 0925 - 1350, as the schedules would be misleading if written the send way.

    So if you can help, or need more info, please leave a message and i can email the worksheets over.

    Thank you

    Scott Pattison

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Hi,

    Welcome to the forum, here's one way to do it using actual time values, then multiply by the cost. Does that help?
    Attached Files Attached Files
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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