time calculation

Hello; I work in a call center that handles several different clients. I am creating a report to allow the operations manager of one of these products to see how long an agent is out of schedule adherence. I am trying to get the report to not only show the time in Hours, Minutes and seconds...

I would like to calculate the time diffrence between 2 dates in DD/MM/YYYY HH:MM format which is easy enough. Howver I need to apply this agains a service delivery model: e.g. date 1 is 01/12/2010 09:00 and date 2 is 02/12/2010 09:00 so the diffrence is 24:00 hrs What I need to take into...

I need to calculate time difference quickly as I monitor a phone call from a specific point in the conversation. I'd like to enter it into a cell as a decimal like .59 (59 second mark) and it might would end at 1.30 (1 min 30 second mark). What formula can I use to get the correct time...

I am trying to process information from a data logger. It records the date, time and corresponding flow velocity Cells in Column A are formatted in mm/dd/yyyy hh:mm Cells in Column B are formatted as Numbers. Is there a method of subtracting 1 date/time cell from another to return a value in...

Hey all, I know this will most likely be a easy answer, but Im going to ask anyway. I been searching for ages now and nothing quite works... I need to find the Penertration rate for drilling over the shift, I have added the meters (E46) and added the drill times (F46). I have formated F46 to...

Hello, I am struggling with date/time calculation in VBA. 1. Can I add/subtract dates as in the next example: Dim vStart As Date, vEnd As Date, vHours As Date dim vHours1 as integer vStart="20:00" vEnd = "23:00" vHours=vEnd-vStart vHours gives me "03:00:00"...

Hi, I have a question about time calculation in Excel. I have a cell that has a number of hours/minutes in it (f.e. 30:43) set as [h]:mm Now I want to subtract 37:30 from that value. so, the result will be a 'minus time' then... is this possible in Excel? Thanx!

How do you convert Cells with text 2 hours 2 hours 1 hour 15 minutes to hh:mm ?

Hi, I have created a pivotable that should sum a range of time values, however all resultant values in the pivottable are 00:00:00. I have checked that the associated fields are all time values. Otherwise I'm stumped. Any help appreciated P

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I need an excel formula in F13:F27 that would take the value in F9 (which is the result from another worksheet) and, when the "Lesson" in C13:C27 starts with the letter "S", accumulate. I...

Hi, any help would be much appreciated. I've looked for a solution but can't find something that meets the specific needs. I need a formula that counts up the accumulated hours per day in a time sheet, then calculates the total lunch time taken during a week and subtracts it to give me the net...

How do I write a formula to calculate the following: start time 08h30 and end time 16h30 to give me an answer of 8 hours?

time worked calculation over 2 days the company I work for has a rule where we can only work 12 hrs in any 24hr time period how can i work this out in an excel spreadsheet if eg: Day 1 start shift 11:30am finish 21:00pm, day 2 start 7:00am finish 16:30pm I'd like to work out how many hr...

I would like to catalog my home movies. I need a formula that would make it easy to: 1. Input Time [Hour Minutes Seconds] without using ":" because I mostly use the number keypad for inputting. Maybe using the period "." as 1.38.24 = One hour, thirty-eight minutes and twenty-four seconds 2...

hi, i have a performance utilization report that exports as an excel file. i have excel 2007. the excel file has two columns of data with column headers. the first column is time. the second column is cpu utilization. the time column cells are in 5 minute increments that include both the date...

Hi, I've got some lists of times in hours minutes and seconds for programme transcripts starting at a random number, for example one of my lists starts at 22 minutes and 30 seconds and then will have different time codes randomly for between 25 and 45 minutes. I need to minus the first value so...

Can someone tell me how to set up a formula to find the difference in hours. For instance 10:00pm - 2:00 am is 4 hours. I can't figure out a formula that will do this for me. Your help is MUCH appreciated! Jan

I have a workbook that teachers use to mark attendance for their class each day. There are two worksheets for each month - one for morning and one for afternoon (named Jan AM and Jan PM, Feb AM and Feb PM etc). The morning attendance sheet automatically updates the afternoon sheet with each...

I am using an if statement as the first field in a row. The statement evaluates whether the elapsed time in another cell (same row) is greater than 30 seconds. The if statement is =IF(H143>TIME(0,0,30),"Y","N"). The value in H143 is 0:00:30 and it has the formula =(G143-F143+(G143<F143)), where...

Hi All, I work with a lot of time based worksheets for a 24/7 operation and constantly use the formula: =IF($E17>$D17,(HOUR($E17)+(MINUTE($E17)/60))-(HOUR($D17)+(MINUTE($D17)/60)),((HOUR($E17)+24)+(MINUTE($E17)/60))-(HOUR($D17)+(MINUTE($D17)/60))) to calculate times worked where $D17 is...