All Questions
12
questions
9
votes
3
answers
35k
views
Excel TEXT function does not work properly
Let say I have the following values in the cells
A1 : `=Now()` which displays 17.03.2014 13:45
A2 : 12.03.2014
Both are in date format and I have the function in another cells like this:
B1 : `=...
23
votes
5
answers
158k
views
How to get time difference as minutes in Excel?
I have time values in two cells in an Excel sheet and I need the difference of
the times in minutes.
The cells in the Excel are like below:
A B C
1 6:38 8:23 1:45:00
A is ...
7
votes
4
answers
23k
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 ...
-1
votes
2
answers
4k
views
How to divide a time period into equal periods in Excel
I would like to find a way of dividing a period of time into 4 hourly time zones. I.e. if a piece of equipment is unavailable from 0900hrs to 1700 hrs that is 8 hours but I need to show this in 4 ...
15
votes
3
answers
74k
views
What Excel formula can I use to calculate the 2nd Monday of a given month?
What Excel formula can I use to calculate the second Monday of a given month?
You can assume I have a cell containing the first day of the month to work with.
In the interests of other users, can ...
10
votes
6
answers
70k
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 ...
5
votes
4
answers
35k
views
How to calculate hours and minutes between two time periods?
I’m working on a very simple time sheet for my work in Excel 2007, but I have run into trouble about calculate the hours and minutes between two time periods.
I have a field: timestart which could be ...
3
votes
1
answer
5k
views
How to add time duration column total from Skype Call History CSV file in Excel 2010?
How to add time duration column total from Skype Call History CSV file in Excel 2010?
These are my exact steps on how to set up my Excel spreadsheet.
How to import Skype Call History CVS in Excel ...
2
votes
2
answers
37k
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 ...
1
vote
2
answers
1k
views
DATEVALUE() gives different values for similar data
In one column, I have timestamps in the format Jun 10, 2015 11:36:51 AM
So, to get the date from that column, I created another column and used the formula
=DATEVALUE(CONCATENATE(MID(D2,5,2)," ",...
1
vote
1
answer
551
views
Date format issue
I export some files from a network as CSV and then I convert that file as excel file there is one column in excel file named-as (dates) now when I apply the filter on it the filter is not slowing ...
1
vote
1
answer
4k
views
Sum the number of hours in Excel
I want to sum the total hours I was worked in a project. For each day, I have:
Starting Time B1: 09:30:00 am
Ending Time C1: 17:00:00 pm
Total Hours D1: =C1-B1 (06:30)
I want to sum the values ...