time calculation

hello i am building a monthly schedule with calcs weekly and monthly, i am using the below calculation. AL2 is the date 26/11/12 (always the 26th of the month) cell calcs= a2 =TEXT(E3,"ddd") .... E3=DATE(YEAR(AL2),MONTH(AL2),DAY(AL2)) .... e4=TEXT(E3,"dd") I need the sheet to show; the...

Good morning everyone, I am back to this amazing forum that has given a LOT to excel community and thank you everyone for that :) So I have this spreadsheet where it is basically call center data so in one of the column it shows time of inbound call as example (21:12:05) and other columns...

Hi all, I want to calculate Working time, which only include time from 09:00(9am) to 18:00 (6pm) on weekdays Monday to Friday only. I m using this Formula I want a formula that can correctly calculate time spend in all the folowing scenarios. > If Start Time is on week day in working hours...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

I have several time data points that I am calculating the difference between. In some of the rows, these times total over 24 hours. I have 4 time data points: order time, exam start, exam stop, and read time. Given these hard coded numbers, I calculate the difference between each step. At...

Data from a SQL database represents time of day as a string of x's when imported into Excel. With CLEAN, I found that noon is -0.5. This means that the calculation being used for noon is (24 * -0.5), or -12, meaning "go to the end of the 24 hour day, then go back half a day to noon." Similar...

Hello Everyone, First time posting here and looking for your expert help. I'm trying to sum times and I'm having a hard time getting it right, I'm importing some data from an ACD software in my call center, I'm getting times that my employees spend on break & lunch but I've found that excel only...

When you are in in excel and have a cell with a date like 11/23/11 13:10:34, and you change the cell to numeric, the value of the cell changes to 40870.55. This number is obviously easy to manipulate and convert back to a date format. How can you do the same thing in VBA. I have not seen any...

I attempted to use the AVERAGE function on a column of response times in the format 00:04:22. I get the #DIV/0! error which says I'm dividing by zero or empty cells, yet that is not the case. I have reformatted the cells using various formats 37:50:22, [h]:mm:ss, hh:mm:ss, etc. Nothing seemed to...

i need held reversing this process <TABLE style="WIDTH: 267pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=354 border=0 x:str><COLGROUP><COL style="WIDTH: 107pt; mso-width-source: userset; mso-width-alt: 5193" width=142><COL style="WIDTH: 101pt; mso-width-source: userset...

Hi everyone, I need to set up a lateness calculation sheet for 50 employees with variable schedules during the week from Sunday to Monday. Workers don't always have the same shift. Can anyone please help me with this. I appreciate guidance.http://www.mrexcel.com/forum/images/smilies/confused.gif

I am making an attendance template that will record the login/logout time of each employee. Each employee has their own file which is linked to a summary file that collates all the information for all employees. My problem is that not all workstations are set in the same region. Meaning...

Hello, I need to calculate the hours and minutes we respond to something but only counting the hours and minutes that fall within 08:00 to 17:00 Monday through Friday. Example - if we received a call at 09:00 06/01/11 but did not arrive until 10:00 6/2/11 hour 'covered' hours are only from...

I am trying to find out the exact sum of time down to the hh:mm:ss on my pivot table from different people on different dates (in half hour increments). Hence: Columns: name name name name name Rows: 01-01-2010 12:00 01-01-2010 12:30 I need a sum of time from each column WITHOUT the dates...

it is a long time since i used excel, and i am a little rusty. Let us imagine we have the following scenario: start end time worked total phone time phone time % 09:00 17:00 08:00 04:00 50% How do I get the phone time % to calculate...

I'm looking for a way to insert four numbers (e.g. 1830, 0830, 1215) into two cells (start /end time) without inserting a colon between the first two numbers and the second (e.g. 18:30, 08:30, 12:15) and ultimately compute the difference between the two times for the number of hours worked in a...

Hello, Please help!!! We have a client who will pay using the 1/4, 1/2/ and 3/4 of an hour increments as follows: From the hour mark to 6 minutes = 0 time paid Over 7 minutes to 15 minutes = 1/4 hour 15 16 minutes to 30 minutes = 1/2 hour 30 30 minutes to 45 minutes = 3/4 hour 45 46 minutes...

I am trying to create a formula that will calculate the estimated completion time of a piece of product. Heres the layout of the sheet: C2 is 6:30AM - (Start Time) C3 is 9:30AM - (1st Break) C4 is 12:00PM - (2nd Break) E2 is 0:36:00 - (Cycle Time of Unit) E3 is 0:10:00 - (Length of 1st break)...

A1 = 18:20:30 B1 = 130 C1 = ? I have a start time (A1) and duration in seconds (B1) and need a formula for C1 to display the new time if B1 were added to A1. In this case, the end time would be 18:22:40. Help, please.

Hi, I have been looking and can't seem to get this to work. First, I have two input files that I store into two arrays (Example Below). I need to link a specific event in Array 1 with that in Array 2 and calculate the difference in time. To make it more challenging there may be an event in...