time and date

How to get E2 & F2? E2=B2-C2 (C2 is in minutes) F2=E2+D2 (D2 is in minutes) B2 is in MM/DD/YY format. Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 108px"><col style="WIDTH: 45px"><col style="WIDTH: 44px"><col style="WIDTH: 108px"><col style="WIDTH...

Hello, I work for a Transport company. We send notification to our customers as to when we will be delivering with a given window of 2.5 hours. Our planned delivery date/time is (G3) 05/05/15 08:19 Our start window for this is (H3) 05/05/15 07:49 Our end window for this is (I3) 05/05/15 10:19...

Dear all, Firstly thanks to all the people who post solutions to problems here, it helps me no end and Ive benefited from the collective wisdom in developing my own VBA skills. Any help with the following would be much appreciated. I have a directory with several hundred files in, sorting by...

Hi, I want to barcode scan time in & out of the employees (from an existing list) as and when they come & go. And at the end of the month want to calculate the total number of hours they have worked. I Will be issuing them with a card containing a unique id, their names with the barcode of the...

Hello Mr Excel! This is my first post so be gentle with me. I am trying to put together a project for work but google is just not cutting the mustard when it comes to providing answers! So here is the scenario, We have a 24hr business which operates a 6 days on 4 days off shift pattern. so 5...

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...

<colgroup><col><col span="6"><col><col></colgroup><tbody> M T W H F S U starting date ending date 1 0 0 0 0 0 0 29/4/2013 7/10/2013 </tbody> hey guys i have the previous data set which represent a flight that starts 29/4/2013 and ends 7/10/2013 and is going to take place every monday i...

I am trying to extract the flight time from a depart date, depart time, arrival date, and arrival time. First I would like to gather all minutes of flight time flown from 00:00-01:00 and so on. Second, I would like to gather all of the flight time flown on Mondays and so on. Third, I would...

I copy and paste the following data from the UBER website. Data before copy and paste: TIME DURATION MILEAGE FARE October 31, 2014 12:50PM PDT 37:05 8.76 $19.22 October 29, 2014 4:20PM PDT 12:18...

Hello, Right now I have a macro set up to enter a time-stamp every time the macro runs. It enters it all as one line, and wrap text is not what I want to do (unless there is NO alternative). What I want to do is convert this: <tbody> more dates 8/6/2014 12:26:04 PM more dates...

I've gotten pretty good with extracting various types of content from cells. But this is a head scratcher. I want convert time values from imported text data, but the time formats are different. I started building a long formula using a series of IF, COUNTIF, MID, FIND, AND, OR, and TIME...

Hi Guys, I wanted to ask for some advice on finding Room clashes (e.g two classes happening in the same room on the same date. My aim is to apply whatever method is advised to a large amount of data (1000 classes in 20 different rooms). eg. below: <tbody> ROOM COURSE START DATE END DATE...

Hi All, I'm struggling with this situation described below: If the day/time on Column B and Column C falls outside the criteria shown below, then I need to insert a row before the next non blank cell, and insert the word "QUERY" in Column D. Criteria: Monday - Friday, 08:00 until 17:00...

Hi I have a spreadsheet which monitors the hours employees work - one of the rules is that an employee must have 12 hours rest between shifts... I am using the below Data Validation formula in column I to highlight when an employee has less than 12 hours rest and an alert to appear...

Hi, Everyone, I am new to this and would like to seek your help computing the number of business hours between 2 dates. Given the following information: - Business Hours: 8am -5pm (8:00-17:00) - Business Days: Mon-Fri - if entry queued falls on a weekend or beyond the business hours, it...

I have a model that works nicely with a time reference every day. The problems starts when I want to take advantage of the fact that I have new data points from measurements every 15 minutes. I would very much like be able to aggregate my data at least on hour basis and not just days in order to...

I need help with a data validation issue. I am trying to use data validation in some cells to restrict what people can enter into cells. In my spreadsheet, there are cells where times are entered and other cells very near this where number values are entered. I was trying to use data...

Column G is the "date/time in" and Column H is the "date/time out." In column I, I have "Turnaround Days" which is just H-G. For example: G2 = 03/06/2013 9:00AM H2 = 03/08/2013 3:00PM I2 = 2.25 How do I edit my formula in I2 to only calculate workdays? I want any time passed over the...

I have several fields which are larger than 24hrs. Is it possible to make sure that excel doesnt start incrementing a date, but instead just allows these records to remain in the hh:mm:ss format? ie its currently converting 36:00:00 to 01/01/1900 12:00:00 but i want the 36:00:00 format. Thanks

Morning Excel and VB wizards, I need some help, more like spoon feeding in fact. I am trying to create a workbook that will be used to record and store appraisals on a network drive and automatically update some cells in another tracker workbook. But before I get ahead of myself I’d like to...