time calculation

Looking for help adjusting my formula in column D (Ceiling) so that instances like D5 would read as 15:15:00 as opposed to 15:00:00. Help is greatly appreciated. Excel...

I want to do two things to the cells in column X. I want the value of cell ‘X3’ to automatically decrease by the value of cell ‘N3’ at the exact same time of day every day using the computer’s clock. I also want the value of cell ‘X3’ to automatically increase by the value of (cells ‘E3 * P3’)...

Hey guys and girls, this is doing my head in - the concept works fine if I write it in cells on a sheet - so it "SHOULD" work in my VBA but it isn't. Quite possibly I am missing the simplest thing and just am too close to see it. Anybody see where I have buggered it up ?? Below are the...

Hi All, I am creating a timesheet using excel 2003 users enter their shift start/finish time and a break start/finish time. Emplyee's can work night shifts (ie across midnight). There are penalty rates which apply at different times. I need to be able to work out the amount of worked time...

In a project i am compiling i need to work accurately with times to calculate the work progress of the people in the workshop thus....here goes.... I have in work book #1 (7) sheets mon to fri + complete week + a sheet where all job numbers are collected. From monday to friday the workmen log...

Hi, my apoligies from the start if this question has been asked a million times before.. I did search the archieves for quite some time.. but no result, althought the format [h]:mm is going to be helpful. I am trying to put together a time sheet.. first adding hours per day, then totaling.. I am...

I use the following sheet to make employee schedules with time ranges. My boss has tasked me to track Employee hours versus customer arrival times. Is there a way I can link my schedule tool to my labor tracker and have it pre populate? Here is the sheet I use for...

Please can someone help...... I would like to add a formula that can tell me the difference in days and time from two cells. An example of the two rows of cells are below <TABLE style="WIDTH: 186pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=248 border=0><COLGROUP><COL...

Hi all. I need to enter elapsed time data manually into an excel spreadsheet. For example, on paper, I'm looking at this: 125:27:32 I would like to be able to enter this as follows: 1252732 Without colons, to save time. I've searched for many solutions before actually asking, and most of...

I am trying to multiply a normal number (1,2,3 etc...) by 20 minutes and have it display in in hours or minutes, whatever it may be. Example: If you do not take a break at my work, you get paid an extra 20 minutes. So I want to be abel to Have a place on the timecard that goes something like...

Hello, I'm trying to get the total amount of time elapsed to be calculated. However, I have cells that record times that go over the midnight threashold. cell 1 = 23:55:00 hrs cell2 = 00:05:00 hrs I want to show a calculated cell that comes up with an elapsed time of 00:10:00 Any ideas?

I'm having difficulty getting Excel 2003 to subtract times. It seems to me that this should be easy, so probably I'm just making a mistake. In Col A I have my arrival time (eg. 08:30) - formula bar shows 08:30 AM In Col B, I have departure time (which *might* be after midnight, but let's...

Hi, I have a list of variables created by a user like this: BAND ID START END Band1 06:00 08:59 Band2 09:00 15:59 Band3 16:00 17:59 Band4 18:00 22:30 Band5 22:31 24:29 Band6 24:30 05:59 Seperately I have data from a third...

Hi, I want to calculate the difference between two times (these will always be in the same day, and will not span midnight). For example: Start time (Cell B2): 08:30:00 End time (Cell C2): 18:00:00 Duration (Cell D2): 08:30:00 I now want to subtract 30 minutes lunch period from this...

Hi, I am trying to create an agenda in which time for each item needs to be represented in minutes as well as time of the day. for example, welcome address will start at 9 am and go on for 30 minutes. i am looking for a formula which helps me calculate the minutes and represent them in terms...