## Using dcounta function on time values

I have a large spreadsheet I use to analyze data. Currently I’m stuck trying to get it to count values of a column that have time values between two …

I have a large spreadsheet I use to analyze data. Currently I’m stuck trying to get it to count values of a column that have time values between two …

Would like to have computer’s current date and time automatically appear in a spreadsheet, in column A and on the next row, at each instance that a …

How do I extract the date if the given data are: 1) Week ending date 2) Days of the week (for which the exact date falls into) See example below: …

Hi, I am bit stuck on a time funciton. I have two times a1= start time and b1 = finish time. C1 tells me the differnece in time as I have …

Hi everyone, I’m trying to create a formula for my overtime, as I get a different pay rate at different days and times. Mon – Fri: 17:00 – …

I have created a form that, when data is entered, will email content to select indiviuals. 2 of the items are entered in HH:MM format, but when the email …

I’m trying to create a formula for time but having no success. I’m trying to create a sheet where meal breaks are automaticvally deducted …

The first table is the input table. The second table is the for the results. The result should display as follow: – If the end date of the …

I’m trying to get my “IF” function to calculate a formula that involves time. So I have a time “hh:mm” in column A and I have …

Everyday I pull up a report indicating when someone took a course for my work. Instead of pulling up in chronological order, the report shows the Day of the …

I’ll outline the situation: I’m assigning different prices for energy being consumed within different time periods within a day. 23:00-7:59 is x, …

Hey, I have this data set which includes phone numbers, length of time of call and date of call. So I want to see how many calls did it take before the …

Hello, I have two tables with different data, in both of them there is time written. I want to match the values where the time is the same (plus minus …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.