time based formula

Hello! I have entered most of my thesis data into excel- and I am looking for a way to avoid re-typing all my columns... I am using Microsoft Excel 2010 I entered times into a column (intended to represent time elapsed, mm:ss) but excel auto-formatted it to time of day (hh:mm:dd). It shows in...

Hello All, I need a timesheet that deducts half an hour when the person works after 1pm, basically lunch is 12.30pm to 1pm and if they take it or not 30 mins are deducted. Therefore the formula needs to deduct half an hour if the time if after 1pm. For information i am using military hours...

I just got a workbook with a Total Time column. However, this column while formatted as h:mm:ss actually represents the time as d:hh:mm. The co worker would like to be able to add JUST the minute column without it converting each 60 min to another hour. e.g. A2 0:13:50 0:13:50 would represent 0...

I have an excel sheet that has information in the following format <tbody> 09/17/14 5:58a 11:31a 09/17/14 12:02p 2:34p </tbody> What formula can I use so the output is an AM / PM - please note there is NO space between the time and the a or the p. This is how I would like the sheet to look...

Hi, I'm trying to create a timekeeping spread sheet for staff. I have a start time column, and a finish time column, both formatted as hh:mm and have entered the time using 24 hr time. I've used the third column to calculate the hours worked using the B2-A2 (Finish time - start time). All of...

Good Afternoon I am looking to carry out an 'if' statement to test if a time value is between 2 values and return True or False. I have read around 50 posts today, but cannot find one that deals with values beyond the hours in a day e.g. 24:00. The closest I have found (and am displaying the...

I have used the information from another post but this is a new type of enquiry. Originally Posted by Ruddles Create the "timestamp info" worksheet by hand, make the top row bold and freeze it. Paste the following code into the code module for your main worksheet - the one where B321...

I'm trying to create a time-sheet in excel, where my employees will only have to select an in/out time and the sheet will calculate their hours as a decimal. I know how to create a drop down list for each field (Start / End). I structured the list to allow 6 minute increments to be selected...

All, I need some help creating a dynamic formula that calculates a percentage based on when a benefit is supposed to begin. For example, let's say we receive the following data about an "Awesome Benefit" that we will start realizing in Q3 2015. 100% will be realized by end of 2017. <tbody>...

I’ve created a spreadsheet to calculate the length of time it’s going to me take to walk a point to point hike later this year. It’s a 100km walk and some of it is done at night, so I want to use a different walking speed during the night period (21.00 to 05.30) as I’m pretty sure we will be...

Hi, First post here, please be kind. :) I am using a Esignal DDE Add-in to pull some data into sheet2, Sheet1 has historical data which needs to keep updating as well. What I want to do: 1- The incoming data into Sheet2(specific Row) has to be copied to Sheet1 based on change in value of the...

I would like to format my cells so that I can input time between 0 seconds and 1 hour, I would like to format the cell so that it only shows mm.ss All attempt so far to format the cells has resulted in the typed numbers being changed as the format tries to include hours. Is there a way to make...

Hi, Can any one help me with a formula that enables excel to copy a value in a cell at a particular time of the day. for example: A1 is having value which it gets from an external web source and is being refreshed every minute. i want the value in A1 at 10:00 AM every day to be automatically...