date and time format

I would like to use conditional formatting to highlight cells that have an actual date and time after the originally scheduled date and time. For example, column 4 row 3, the delivery time is 18 minutes late - I'd like to highlight that. And in row 4, it's a day late, that would also need to...

How can we restrict only dd/mmm/yy hh:mm format in an excel cell ?

Hi, I have a table where I have summed up a number of "times" and I want to present these sums in a bar graph where the y-axis is in number format DD:hh:mm:ss. My problem is that the y-axis starts from "30:00:00:00" instead of "0" even though I have stated the Axis bound to 0-5. I have...

I have a dashboard in a workbook that displays a number of charts that have their data stored in a different workbook. This is so that we can update the data upon demand and independently of the dashboard (as it may have a number of concurrent viewers). It works pretty well on the whole, but...

I am managing the volunteer hours for a volunteer fire department. In a nutshell, the member logs in to the website, fills out a form, and then at the end of the month, the admin exports the data. The website template provider doesn't allow us to change the export features, but we can change the...

Hi guys, I'm working on a "membership" database for a greyhound rescue volunteer group, to try and help them organise things a bit better (their "manual" system wasn't too flash). I've got things working (for the most part) how I want them to... just fixing minor issues as they come up, now...

Hi everyone, First: I am trying to separate 07/02/2016 02:10:28 into a date and time column any suggestions? <tbody> next: I want to count how many are between 2am and 3am I have seen this somewhere but, do not remember where I saw it. Thanks, Dennis </tbody><colgroup><col></colgroup>

Hi, I have a database which cannot be changed. When I extract all the data out there are several fields in date format. However over the time it has been populated into about 5 different date formats from DD/MM/YY to MM/DD/YY to the aforementioned with the time after it etc etc. I was...

Hi Guys, I am currently working on a holiday request form and I am at the very early stages of it. I was just wondering if anyone could help me with integrating the below formula into VBA please as I am a complete newbie. =IF(C21 ="Jan","01",IF(C21 ="Feb","02", IF(C21 ="Mar","03" ,IF(C21...

Hi All, Apologies if this question is about I did search but could not find anything that could help me. First off I am new to the forums and after taking a brief look, it seems to be a great place to get excel knowledge/tips. Explanation/Question: I have a fairly large data extract I do...

The data in my worksheet is being stored in the database as a timestamp even though it's a date. When i pull the data and copy it over i need a quick way to look through multiple sheets for a defined header or column and format it from timestamp to date. the below example does exactly that but...

I'm using a form to put criteria into a query. I'm using date ranged but if i input date range <code style="margin: 0px; padding: 1px 5px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New'...

Hi, Using Now() function i have displayed the date and time in cells(4,1) as 2/10/2015 15:20. However, in next cell i need to display the time with the addition of 2hrs without changing the format. I'm getting time mismatch error if i use the below code. Code: Cells(38, 8) = Now() + Time(2, 0...

Hi, I am trying to get a cell to auto format the way that I want it to. The load sheet that I am creating is used by people that are in the habit of entering dates in the MMDDYY format, but I need it to be in a YYYYMMDD format in order to load properly. Is there a way to set it up so that if...

Hi, I am after a formula or VBA, which works out the total hours and minutes between two dates and times: i.e. A1: 11/11/2014 21:00 A2: 12/11/2014 06:00. Essentially I need the total hours and minutes between Cells A1 and A2. Excel has difficulties with 24 hour periods and formulas I have...

Hi, How would you get a vba defined string e.g. "050914" to be ouput in a cell as "05/09/2014" (or just "05/09/14") It must be classed as an actual date, not just a string in the cell for sorting and ordering etc. Thanks in advance.

I'm trying to identify which employees work at night. Between 6:30 and 23:00 is day time. Outside is night time (just by getting part of it). Without using VBA is there any formula in excel to this? Example: <tbody> A B C 1 Employee name Work Time Identification 2 Andrew 04:00 - 06:00...

Good day everyone. My first post! I've downloaded a csv file from my companies ticketing system and need some help to make use of the data that is contained within it. I'd like to separate the date and the time into different fields. I've tried using the "left(text,[num_char]) function, but is...

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, I have in column A dates: 31/12/2014 31-11/2013 03/Mar/2014 05:11 AM 04-Jan-2013 07:45 How can I simply in column B select date, to have it one format: DD-MM-YYYY ? When I'm using function "DATE" = date(A1;A1;A1) it didn't work.