time between dates

I have a table that calculates values for hour blocks based upon the start/end date and start/end time. The hours are listed in the columns and for each row the user adds the start and end time. No entries are more than 24 hours but very often entries do span two different days, for example...

<tbody> Completion Date Completion Time Reported date Reported time 01.05.2019 12:07:06 01.05.2019 11:25:27 02.05.2019 15:24:49 02.05.2019 14:16:31 </tbody> Hi, Any suggestions how I calculate working hours taken from reported to completion. Working hours are 8.30am to 5pm and...

Hi there. I'm absolutely no expert on excel. But, I'm a new manager and need to create a schedule for the team to use. I want to include the 30 minute break to make calculations easier for my boss. We work on a two week schedule (Mon-Sun) and I don't want to have 2 sections blocked off for...

Please help. Looking for an equation that will calculate the Max concurrent rooms in column D between each start and stop date/time. Column D has what the correct answer would be. If possible would also like the MIN in column E which also has the correct answer. Correct answers are included to...

Subtract dates and times for overtime ...and also consider weekends and holidays PLEASE PLEASE HELP I need help with a formula to deduct ie dates and times to calculate regular time and overtime and multiply the regular time with the basic salary of R18.75 (Rand)....and Saturdays with...

Hello all, Hopefully I can explain this clearly... I am currently trying to calculate the hours/minutes from Time Range A (which is a recurring schedule of APPROVED time ranges) that do NOT overlap with Time Range B (which is a larger data set of different login periods). Basically, users will...

Hello Everyone, Could some genius please help me with formula or ways to find a daily occupancy rate of car park in hourly bases based on transaction of “Date Time IN” and “Date Time OUT”. ? Below are the actual sample of transaction we receive. Note: Drivers can park for more than a day as...

Hello, I need the result in column "B" as a minutes only. The column "A" can have dates more than 10 days but still the results need to be in minutes. Any help is more than welcome :) <tbody> A B C 27/Mar/18 09:00 27/Mar/18 11:00 120 </tbody>

Hi! I need to calculate the time [h]:mm:ss between 2 different dates. working hours are monday-sunday & times are 05:00:00 - 18:00:00 Public Holidays should be excluded! Example: A complaint was lodged on 26/09/2017 09:00:00 Solved 29/09/2017 15:00:00 28/09/2017 is a PUBLIC HOLIDAY I...

Hi all, I need to count the total time spent for one task among various people, by counting the starting time and ending time of the sub-events. Example here: <tbody> Event 1 1 2 2 3 3 Time S E S E S E Alex 1 Jan 2 Feb 3 Mar 4 Apr 5 May 6 Jun W days Brian 2 Jan 2 Feb 2 Jan 2 Feb...

I am trying to figure figure out how the length of time between two dates (an online and offline date). First the facts: Windows7 & Excel2010, I have tried formatting the cells to 'Date' which does not help and I have 1000+ date ranges to calculate. The formula I found to do this is...

Hi I have data showing when staff arrive at, enter after clearing security and then exit a building after completing their task. The data for each cell is a combined date and time as opposed to separate cells for date and time. I am trying to ascertain how long our security staff take to clear...