+ Reply to Thread
Results 1 to 2 of 2

Calculate start and end time and allocate each hours into respective hourly slabs ?

  1. #1
    Registered User
    Join Date
    11-14-2016
    Location
    Bangalore
    MS-Off Ver
    ms office
    Posts
    1

    Calculate start and end time and allocate each hours into respective hourly slabs ?

    sample.jpg

    I have tried my best and couldn't achieve what is required, Can anyone help me to crack this one please.

    Start End Time difference 11:00 AM 12:00 PM 1:00 PM 2:00 PM 3:00 PM 4:00 PM 5:00 PM 6:00 PM 7:00 PM 8:00 PM
    8/1/2018 11:18:55 AM 8/1/2018 2:51:17 PM 3.54 0:41 1:00 1:00 1:00 0:08 0:00 0:00 0:00 0:00 0:00

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,424

    Re: Calculate start and end time and allocate each hours into respective hourly slabs ?

    Hello kumar.siddesh and Welcome to Excel Forum.
    Not guaranteeing that I or anyone here can help, however there is a better chance that someone can if we can see the spreadsheet from which the screenshot was made (I assume the data isn't sensitive as it is in a screenshot).
    To upload a spreadsheet (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] to calculate credit days based on time slabs
    By Vivek2705 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-11-2019, 06:49 AM
  2. Replies: 2
    Last Post: 11-03-2016, 09:47 AM
  3. Calculate start date & time of task (working hours)
    By kaaver in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-30-2016, 10:56 AM
  4. [SOLVED] Calculate time for working hours when start time falls outside of working hours
    By SKDY_Beau in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-20-2014, 12:50 PM
  5. [SOLVED] How do i calculate work hours from only a start and finish date and time?
    By transitsolutions in forum Excel General
    Replies: 1
    Last Post: 02-28-2013, 03:39 PM
  6. Replies: 0
    Last Post: 02-07-2013, 08:42 PM
  7. Calculate finish time given start time, working hours and job duration
    By swanseaexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-23-2012, 03:00 PM

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