+ Reply to Thread
Results 1 to 2 of 2

Help with time calculation formula

  1. #1
    Registered User
    Join Date
    06-25-2011
    Location
    Boston
    MS-Off Ver
    Excel 2007
    Posts
    25

    Help with time calculation formula

    I'm ultimately trying to create a formula that will calculate all types and formats of a continous work schedule, including working that over lapse days.
    The schedules would show only with one date which would be there start date, and one cell combined start time and end time, 09:00-17:30. I have included a sample file, with the formulas i've been using.

    Thank you I appreciate any assistance

    MZING81
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Help with time calculation formula

    Hi Mzing,

    I am not clear with your request.. are you looking forward to have some kind of formula in column F?
    Please provide results manually which you wanted to achieve using formulas. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ 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