date & time

I am using Microsoft Excel 2011 for Mac. I have a phone log that I want to report some data off of. All of the solutions out there that I have looked up seem to assume I only have a time value and that they don't include an actual date. I have a bunch of dates like this: 2/1/16 3:39 AM...

Hi, I am trying to convert the following 13 digit json number -> 1452002465000 to date/time. I am using this formula ->=D7/1000/86400. This is giving me 03/01/1946/ 12:28 PM. The time is correct but the date is wrong (should be 05/01/2016)

i am trying to create a proposal from information that i gathered about a month ago. I would like to input a formula that shows todays date if information changes in cell M23 but doesnt change every time i reopen the document. i am not going to be physically changing the data in cell M23 it will...

Hello, Currently i run a weekly report that drags in the past weeks breakdowns and i am trying to find a way to delete a whole row of cells if the time is before 8AM. I have had a number of attempts but i cant get anything to work; Sub DeleteRows() Dim i As Long With Sheets("12 hr Nights") '...

Hi, I want to create a formulae to see how many things are due and overdue by 24h/48h/72h/5d/10d/>10days. All things due or overdue will say "In Progress" in column AD and the Completion Due Date and Time is in column U. My formulae for Due in 24h is: =COUNTIFS(Data!$AD:$AD,"In...

Hi, I am looking to work out if a list of items have been Completed, Due or Overdue. For completed, it should be in last: 24h, 48h, 72h, 5 days, 10 days. For Due, it should be in next: 24h, 48h, 72h, 5 days, 10 days, more than 10 days. For Overdue, it should be overdue by: 24h 48h 72h, 5 days...

Hello, I have in column C a long list of date and time in the following format: <tbody> 01/05@0558 </tbody> Where 01/05 is the date and 0558 are the 5:58 AM How can I split the format in two different columns and with the correct date (mm/dd/yyyy) and time (hh:mm) notation? Thank you so...

I have data that is formatted like so... <tbody> calldate 12/12/2015 18:52 12/12/2015 16:50 12/12/2015 16:17 12/12/2015 14:00 12/12/2015 13:44 12/12/2015 13:35 12/12/2015 13:11 </tbody> I'm running a macro, and one part of that macro is to separate the date/time column into...

My data has two columns (a start date and an end date). I need to be able to select a date and see which projects were active at that time. <tbody> Start Date End Date Funding 6/25/2012 6/24/2015 $200,000 1/1/2010 12/31/2014 $500,000 etc. </tbody> For example with the data above how...

Hello, I was wondering how I would go about putting together 2 separate formulas for the case below: I have table, within the table I have a column named " Status" and "Date of request". Within the "Status" column, I have two filters: "Waiting on dealer" and "part is locked" I would like...

I am trying to build a patient tracker (aka Date Tracker) in excel, my requirements are the following: 1) I need to be notified within the first 48 hours of release date —excluding weekends. 2) Again notified within 7 days with weekends of release date. 3) Again notified within 14 days...

Hi All, I spent hours upon hours experimenting with formulas and searching the internet for answer. :( I have data range extracted from our company system with date and time in one row and I'm trying to set the formula not to count a cell where the time is 00:00 (no matter what date) What I...

My data set has Name, Assignment, Start Date, Start Time, End Date and End Time as well as a field that has the calculated hours worked. Under the Assignment field there are 5 categories. I need a formula that will give me: If assignment #1 AND assignment #2 were covered each day during the same...

I've got a list of names & dates (person X available on 16th Sept from 09:00 to 12:00 type thing) which I'd like to show visually so it looks like a calendar. I'm thinking the calendar would be a little table with days in columns & half hour time slots in rows. I was wondering if I could pop...

First off, thank you for your help and taking the time to read this. Here is the situation I am trying to solve: I have two date/time stamps per transport unique identifier, I am trying to write a formula that says if on a given date, how many active transports occurred that were not...

Good Morning, Could I please ask for your expertise in assisting me with a query I currently have. Without the use of macros. I have created an incident tracker that captures the service requests my team action on a daily basis. Incidnets are received via email and then logged into our CRM...

Hi I have source data into sheet1 like: <tbody> ColumnA ColumnB Audi 01/01/2015 Audi 30/03/2015 Bmw 06/06/2015 Audi 15/07/2015 Bmw 02/02/2015 </tbody> Into sheet2 I have unique list of values from columnA: <tbody> ColumnA ColumnB Audi 15/07/2015 Bmw 06/06/2015 </tbody> How to...

Hi, I am trying to find out a way to automatically insert the date in column H, when anything in columns A:G is modified (when in the same row). For example if I modify E3, I want the current time to automatically put in H3. The sheet is called "Master List". I tried looking at some of the...

I have a workbook with a over 100 sheets and at the end I have a template where I have a macro that copies the template and does some work with pivot tables and it is working well. What I would like have happen is for the new sheet (Template(2)) to be named in mmddyy form one business day after...

Hello, I'm new to the forum, but I use the site for help all the time. Usually I am able to figure it out based on other issues threads, but this one has me stumped. I am looking to run two subs, one to remove extra characters on the barcode scan itself (see below for code). Private Sub...