All Questions
101
questions
-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 ...
2
votes
1
answer
1k
views
How do I convert dates from Open Office format to MS Excel format
I am trying to save a file in Libre Office as an excel file but Excel sees the data displays it as a negative number using a series of ###### symbols.
I believe the problem is to do with the two ...
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 ...
0
votes
2
answers
364
views
Calculating time between 5a-1p or 530a-130p
I was wondering if it is possible for Excel to calculate time span if each time block is in 5a-1p format in one cell. That way I could add the hours for each week without changing too much.
Sample ...
1
vote
2
answers
10k
views
Return day number in year from date in Excel
I am trying to show the date in an adjacent cell as the number of days in the year.
Jan 1 would be 1, Feb 1 would be 32, Dec 31 would be 365.
Also the reverse, how many days are left in the year.
Jan ...
-1
votes
1
answer
255
views
Calculating Time Differences in Excel
I would like to calculate time differences within Excel but am having trouble with the formula.
I am comparing a screen time to the actual speaking clock time.
e.g
Speaking clock = 13:00:00
...
-1
votes
1
answer
5k
views
Calculating Dates Backwards in Excel
I am trying to calculate 6 Fridays before a certain date, as well as 4 Fridays before a certain date, in order to establish deadlines for several departmental responsibilities. I would like the dates ...
-3
votes
2
answers
26k
views
How to calculate monthly sum from the entries for each date in Excel?
I have colums for my workout logging:
Date
Running (minutes)
Pushups
Pullups
Crunches
and the rest of my workout entries.
I insert my achievements each day.
How can I script Excel to automatically ...
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 : `=...
0
votes
1
answer
2k
views
Excel convert [h]:mm:ss to a decimal format
I have this cell with an [h]:mm:ss format, and would like to have minutes only, with 2 decimals after the coma (and not seconds).
For example:
A1: 2551:26:38
becomes
B1: 153086,63
How do I do ...
0
votes
2
answers
2k
views
Excel function for calculating total spent time
I have an excel sheet, where in some columns I have cells of the type integer,integerM or integer,integerH, for instance 1,30m or 5,2H. For all the column I would like to get an expression that checks ...
0
votes
2
answers
2k
views
Excel multiply days and hours with a factor
I would like to calculate the time span betweeen two dates with excel and multiply the amount of days with a factor - like 2 d and 10 h * 5$
Its easy to get the days and hours by just substracting ...
2
votes
3
answers
1k
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 ...
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 ...
10
votes
4
answers
74k
views
How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)?
How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)?
Excel File Origin
I have an Excel file that was originally a CSV file. At this time I don't have ...