time and date

Dear all, I have the duration data for more than 40000 rows in the number format. I need a method to convert the same into time format in excel. BY saying number format i mean 1 Hours & 45 minutes has been given as 1.45. I would like to have the same value 1.45 in the TIME format in excel so...

Hi all, Long time luker now hoping for some help. please. We wish to maintain a running log of prodcution scheduling. The format we have been attempting is (E1)Print Date & Time (F1)9/21/2016 (G1)4:55:36 PM Job Number Part Number Description...

We have time and date data from our ordering system, we want to be able to see the trends in which day of the week/time of day are the most common for orders being placed. This is what our data looks like (copied out of excel, formatting in excel is two columns, Name and Created date, date and...

Hi All, This is my first question. One of my work is using VBA to copy certain number and date from each binary workbooks (there are tons of workbooks) without opening them. And paste them into one worksheet from a new workbook in time order. How should I accomplish that? Thanks...

Hi, Someone can help to me? I have two time data in column E and column F For example: ColumnE 12:30 ColumnF 18:11 The rule is the following: If StartTime is greater than 12:00pm, then show total hours (column Q) between 18:00 and 22:00 So 12:30 and 18:11 -> 0:11 or 14:15 and 21:15 -> 03:15...

Hi, I have a pb with the cells formatting for a time: In a cell let's say A1, i would put a time, for ex: 08:00 and I would like to retrieve this value for the use of an Application.OnTime function However excel considers my 08:00 as 0.3333. I tried to format my cell A1 in time category but it...

Hello all, Is it possible to run a message Box from a specific date until someone opens the spreadsheet? So I have 3 dates in question: April, August, December 26th. Is there a way to have a message box display on those dates up until the spreadsheet is opened a 2nd time? See Timeline...

I work in Advertising Sales and when I send clients their daily logs in excel, some need to have day parts added to the corresponding time slots. An example of this is: Date Scheduled Time Aired Program Name 7/4/2016 6:48:08 AM Early Morning 7/4/2016 6:50:08 AM Early Morning 7/4/2016...

I am trying to make a sub that when run (a button is clicked) it adds one to the value of a particular row based on what time it is. for example, my sheet has an hour in 8 rows column B (based on what shift is using the program the times will differ) When the button is hit It needs to add 1 to...

Hello Excelians, I have to calculate a 24hr SLA between date/ time Received in the following format of 0/0/00 0:00:00AM and date time Sent in the same format. ( Column A Received and Column B Sent) and Column D will display the time in between in the 37:00 hr format. A simple subtraction...

Hi there! I'm trying to make an "Index" page that will update the time a sheet in the workbook was edited. so far the code I put in each worksheet is Private Sub Worksheet_Change(ByVal Target As Excel.Range) Range("A1").Value = Now() End Sub Then I'm calling the Value of A1 in the Index sheet...

Hello. I have a large data-set (part of which is shown below) and am trying to take the daily average of each column and export it to another sheet (example shown further below). I would assume VBA is the only way to do this, but I'm rather new to excel coding and am not sure how to go about...

Hi All, I send out emails via a macro. All of the emails' information are found in the workbook. What I would like to do next is once an email is sent out, is there a way to return a value to column L? It would simply be something to just let me know that the email was actually sent out, and if...

I have data set of times. I want to round the each time to nearest 10th minute. A sample of data set & expected answer is shown below. Thanks you very much for your time. <tbody> 8:11 8:10 7:57 8:00 8:03 8:00 4:33 4:30 5:08 5:10 </tbody>

Hi all, I am trying to make a sumifs formula work on my spreadsheet, however for some reason it gives me the same result for all cells (0?) Here is how the formula looks: Let Cells(x, y) = Application.WorksheetFunction.SumIfs(Unit Quantity, Sale Date, Cells(x, 1), Sale time, "" >= "" &...

Hello, I am creating a weekly room booking sheet, and I want to make it clear to users when they input a time that if it starts before the end of the previous time, then a warning will pop up. Using data validation, this should be relatively easy. However, I can't seem to get it to work. The...

<tbody> (A) day (B) calldate Friday 01/05/2015 14:11 Friday 08/05/2015 11:47 Monday 09/03/2015 14:40 Friday 22/05/2015 15:33 Tuesday 19/05/2015 16:13 Tuesday 10/03/2015 09:24 Tuesday 12/05/2015 11:34 Monday 30/03/2015 11:55 Tuesday 21/04/2015 09:49 Friday 10/04/2015 15:54...

Hello, I was hoping someone would be able to help me out with an excel problem I have. I have a spreadsheet which contains data in one minute intervals in the following format: <tbody> <tbody> A B C 7/16/2015 0:00 2.4 5.3 7/16/2015 0:01 2.2 4.1 7/16/2015 0:02 2.8 6.2 7/16/2015 0:03...

I work with generators and 100MB time series CSV data files are generated every day (250K rows), as shown here: https://www.dropbox.com/sh/d57qcdkx6087u72/AACv4MqXDmpVrxN-Qci0Pjida?dl=0 I am interested in zooming in/out of chart that has 4 variables plotted against time. Then consolidating...

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