## 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 …

## Automatic Date and Time Input

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 …

## DATE

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:   …

## Help with a time function

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 …

## If statement between times and days

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 – …

## StrBody display entered info as hours

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 …

## Time formula

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 …

## Vlookup with Today() formula

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 …

## “If” Formula

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 …

## Sorting Extensive Dates and Times

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 …

## if and and time

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, …

## Counting cells

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 …

## Search and copy a time in between two values

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 …