date and time

Hello I have been trying to find a macro that autamatically fills 3 different cells with date, updated date and name of user, when someone fills certain cells in a worksheet. i have 2 macros that work independently. but i cant make them work together: (Optimally i would like to have the macro...

Hello. In cell A1 I have current date created with formula =today() eg. 3-Oct-2019. In the same column starting from cell A3 (A3:A600) I have dates and time in format dd.mm.yyyy - hh:mm (example. 04.10.2019 - 21:00). All those cells (A3:A600) are text cells. I need to subtract all those...

Hello Excel gurus! I need help figuring out a formula to calculate thenumber of patients existing within certain timeframes. Our goal is to determine how many nurses weshould schedule during 3 shifts: NOC (graveyard), AM, and PM. Any ideas? I’ve been pulling my hair out on this one. Failed...

Hi Is there some vba code that can check whether a cell has a Date and Time or just a Date? So 01/04/2019 is good, but 01/04/2019 05:20 should flag up to say "No". Thanks

Hi, Can anybody please help me edit my clumsy coding please? I am trying to apply a filter that selects any date apart from dates within the last month. So if I use today for an example the filter will filter for all dates before and including 30/10/2018 because today's date is 30/11/2018. So...

Hi, I maybe overlooking clues I can see on the internet but I am still having trouble converting date and time (day-month-year-mins, sample below) into unix timestamps. Would be most grateful for help please. Alfie101 <colgroup><col></colgroup><tbody> 20/4/2017 30 20/4/2017 32 20/4/2017 39...

I have tried everything out there from google search to youtube videos but cannot find anything to help me get to the below example. Does anyone have a formula that would work? The top set is based on the date and time in column b. The bottoms set is based on the date in column b and the time in...

Hello, I'm trying to set up Cell "B1" to pull the date and time from cell "A1" and then Format it to the Date/Time format. Cell "B1" pulls the information from "A1" using the formula below. When I try to change the format to Date/Time Cell "B1" is not effected. <tbody> A B 1...

I'm currently trying to add a date stamp (column A) and time stamp (Column B) after inputting data into column D for the first time (i.e. no updates in time or date after the first entry of a specific row in column D). The input, date and time should be on the same row. I've hunted around and...

Hi, Little bit workload but I need to figure out a calculation for this meal allowances with formulas: A truck company pays their drivers a meal allowance but only when they are not driving and out of the base, the allowances are: 1- Breakfast 20USD from 7:30 to 9:30 2- Lunch = 40 USD from...

Hi there, I want to display the age of animals based on the date they were born relative to the current date. That part I think I can figure out. However, I want to display it in a way that if the number for the year or the month is zero, it would not appear in the cell For example, a dog that...

Hi Everybody, I work for a company that has a lot of projects with a deadlines, usually we prepare for our projects 110 days in advance, so if the project is due to be finished on 01/07/2017, we need to start planning 13/03/2017, so we just substract the 110 days from the date and get our date...

I am using Access 2013 and have tried everything to get this to work. I just want a record to be stamped with a modified date after any part of the record is changed. I cannot figure out why this isn't working. I created a new field called Modified On with Date/Time format in table1. I then...

Hi guys, I have a question that has been on brain for the last couple of hours.... I am working on an attendance tracker and each month of the year has its own sheet in the same workbook. Then I have an overall sheet. On the overall sheet I would like a column for to find out how many points...

Hello All, I have a datasheet in form of Excel table with different columns of data where I want to convert the first column (Time) including date and time information in each cell from string format to readable date and time format using VBA. Time 30.11.2016 14:20:44 30.11.2016 14:20:45...

Hi i have this formula in my cell =FILTERXML(WEBSERVICE("http://api.openweathermap.org/data/2.5/forecast/daily?q="&AE1121&"&mode=xml&units=metric&cnt=14appid=bd82977b86bf27fb59a04b61b657fb6f");"/weatherdata/forecast/time[@day='"&TEXT(N1119;"YYYY-MM-DD")&"']/"&AC1126&"/@"&AD1126) I want to stop...

I cannot seem to find information about what i need a VBA code to do. If anyone can help me, that would be greatly appreciated. I have this spreadsheet to log the customers that recieve service, date of service, amount they owe, and if i recieved payment or not. (Income sheet) Date...

I cannot seem to find information about what i need a VBA code to do. If anyone can help me, that would be greatly appreciated. I have this spreadsheet to log the customers that recieve service, date of service, amount they owe, and if i recieved payment or not. (Income sheet) <tbody> Date...

Hi everyone, First time poster here, appreciate any and all help. I have an excel document that continues to convert dates to numbers, and I have no idea why. For example, 2/2/14 changes automatically to 41672 and 4/4/14 changes automatically to 41733 (left adjusted in the cell). The cells...

Hey, I'm needing to create a workbook for the scheduling department within my company. The scheduling department needs to make courtesy phone calls to all our customers. A call needs to be made weekly to customers keeping them aware of the progress with their order. If possible, I would like...