# Tagged Questions

79 views

### Excel date & time formula-round up cell value

I'm preparing a report of usage statistics for a group study room reservation system we use at the library where I work. I've exported all the reservations from MySQL in Excel for the past year and am ...
175 views

### Calculate number of Sundays in the month

In Microsoft Excel I am looking to determine the number of Sundays in any given month. I am putting together a budget spreadsheet and some of the sub accounts get extra funding when five Sundays are ...
78 views

### Using Excel to calculate time differences with blank cells and calculate monthly totals

I have a sheet that looks like this: Level 1 Level 2 OFF Date Time Date Time Date Time Total T Total L2 12/3/2013 12:50 ...
138 views

### How to make excel return a date from a column corresponding to the last 'YES' in a different column

I'm trying to develop a spreadsheet tool to help track the training currencies of professional aircrew. In order to be considered 'current' in all training, aviators must accomplish a variety of ...
67 views

### vlookup datetime FALSE; return value from 1 of two columns based on exact datetime

Based on data below, I am trying to do a vlookup such that if the datetime in ends in 18:59 return the value in column_3, if the datetime ends in 6:59 return the value in column_4... 10/7/2013 18:59 ...
267 views

### I neet to convert date value into date/time value in a cell

I have a cell with 07/26/13 and I want a formula to take this date each day it is updated and convert it to 07/26/13 00:00, so that I can make a formula in another cell with a time reference of IF ...
1k views

### How to calculate age in years?

In Excel 2010, I'm using the formula =(TODAY() - 05/31/1996) / 365.25 to calculate the age in years between today's date, May 30, 2013, and May 31, 1996. I'm expecting some number close to 17.00, but ...
394 views

### Is this the best strategy for displaying a negative time value in Excel?

I am trying to send up a calculated cell as duedate - now() in order to quantify overdue vs. time remaining (negative values = overdue, positive values = time remaining). Consider: Col A ...
125 views

### Excel date formatting after formula calculation

Say I have the following two dates in column 1 of my spreadsheet: Tuesday, February 12, 2013 10:13 AM 2/12/2013 10:13 When I highlight the column and change the cell formatting to a date type of ...
7k views

### Calculating a duration in excel from date and time

I have 2 columns in excel, each column includes a date and a time in the following format: 'dd/mm/yyyy hh:mm'. One is a start date/time, the other is an end date/time. The end date/time could be ...
156 views

### Excel Date Formula with a condition

I have 3 fields in excel as follows: Cell A1=2012 A2=12 A3=15 which contains year, month & date value respectively. And I want to make a date string out of it. I know it's very easy to achieve ...
1k views

### How can I compare Excel serial dates WITHOUT converting to mm/dd/yy type dates?

I have a table that contains a number of values representing Excel serial dates. After a number of unsuccessful attempts to compare fields, my current approach is to do comparisons between serial ...
4k views

### How do I `SUM` by multiple columns in Excel

I have a comma delimited file that includes two columns date/time (which imports as Excel's mm/dd/yyyy hh:mm custom format) and status of 1 or 0. The status represents a piece of equipment either ...
5k views

### How do I calculate number of hours > 24 in Excel?

I've got an excerpt of my spreadsheet below. It's a time tracking application containing a start date/day, a session ID and the duration of the session. Column A is populated by adding the duration in ...
740 views

### Why is there a date in my Excel time format, and how do I get rid of it?

I am using ExcelÂ at work and I have a list of users' online times. I get a total say 180:30:00, which is 180hrs 30 mins and 0 seconds. I need to keep this cell as the time, but I want to work out ...
4k views

### EXCEL: How can you FORMAT a serial number into a MONTH ( Jan, Feb)

I extract the Month() number out of my date. I now want to change that number into a recognisable string Jan, Feb, Mar, etc. In Access you can use FORMAT, but what can we use in Excel? E.g. ...
2k views

### Excel: Summing values within a certain date range (> start date and < Finish date)

How do I include a 'Between these dates' criteria inside a SUMPRODUCT? =Sumproduct((RangeName=Cell A1)*(RangeDate=Between 01/03/10 and 31/03/10)*(RangeCost)) What's the way to manage dates ...