All Questions
101
questions
0
votes
3
answers
630
views
How do I get the sum of hours:minutes in MS Excel in the status bar and in a formula if the cells come in with a text format?
I know that there are questions around that are much the same, like Sum the number of hours in Excel, which asks you to format [h]:mm, which I do and it still does not work.
Also not so far is How do '...
- 2,423
1
vote
1
answer
544
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 ...
- 11
0
votes
1
answer
1k
views
SUMIF all times between a start and end time of each day
I have an interesting one which I am really struggling to resolve and feel this should be possible using SUMIFS somehow!
I have the following (as per the image):
I have a number of tasks to complete ...
- 3
0
votes
1
answer
1k
views
Removing date from datetime (VBA Excel)
I need to delete the date from mulitple rows with a datetime value. Or extract the time to another cell.
For example:
A1 = 3/11/2022 10:20:00
A1 after macro = 10:20:00
or
A1 = 3/11/2022 10:20:00
A2 = ...
- 1
0
votes
1
answer
610
views
Increase time by 15 minutes by 4 rows per 'time slot'
I'm trying to create a list of certain times for people to sign up in a form.
I did the following by hand, but I'd like to use a formula for it. Looked over the internet for iteration formulas for ...
- 143
0
votes
1
answer
2k
views
Excel Date Timezone Conversion [duplicate]
I have a spreadsheet from a system that outputs the date and time format like this:
15/09/2021 04:29 AM
The format of the field/cell is Custom:
dd/mm/yyyy hh:mm
How do I convert the output so that ...
1
vote
2
answers
137
views
12 In 24 working hours
How do I calculate the number of hours worked within 24 hours?
If the shift starts at 6 AM and finishes at 2 PM with a half an hour break, and the shift the following day starts at 4 AM and finishes ...
- 13
0
votes
2
answers
807
views
=DATE() won't increment DAY when I try to drag or fill the other cells
I'm working on an excel file to track attendance. The excel sheet should have the flexibility of dynamically changing the year of dates. The user can enter the current year in a cell and it should ...
- 101
1
vote
2
answers
1k
views
Excel won't recognize timestamp in format of "m/d/yyyy h:mm:ss AM/PM"
I have a column of timestamps (strings) formatted like so:
This can be deduced to the following format: m/d/yyyy h:mm:ss AM/PM
I'm trying to get them to be formatted into dates but Excel refuses for ...
- 115
0
votes
6
answers
1k
views
Excel date convert from Mar-29 to 29/03/2020
Simple question that I have not been able to find an answer to.
I have some data that doesn't have years and is formatted as Mar-29, as I have pasted into Excel, but Excel converts this into data ...
- 796
-1
votes
1
answer
6k
views
How do i remove date from a date and time from an excel cell
I have a very huge sheet with date and time values. I am exporting the calendar start date and end date into excel from outlook. I just want the time value in the field. Upon searching i found an ...
- 1
1
vote
1
answer
877
views
Determine number of non-Sundays in a part of a month
Calculate number of Sundays in the month asks
how many Sundays there are to the end of the month.
Two users proposed very similar answers that I liked and worked very well to determine how many ...
- 13
1
vote
3
answers
13k
views
Excel =TIME() with values over 24 hours displays incorrectly
I'm trying to display times over 24 hours in Excel by using =TIME() but when the values get over 24 hours they display incorrectly. For example I have =TIME(27;42,81;49) which should be displaying 24:...
- 113
0
votes
1
answer
346
views
Excel Formula : Find out time spent in specific time ranges
Trying to work out a slightly more complex overtime worksheet here:
Employee gets paid:
1x hourly rate during weekdays (Mon-Fri) during 08:30 to 17:30
1.5x hourly rate during weekdays (Mon-Fri) ...
- 143
0
votes
2
answers
10k
views
How to get time difference from cells formatted as dd/mm/yyyy hh:mm in Excel?
I have two columns of dates and times, formatted as Custom dd/mm/yyyy hh:mm.
A third column is =C3-B3, =D3-D3, =x3-x3, etc.
As you can see, it does not tell the difference in days, hours and minutes,...
- 23.1k