## Conditional modifiers for Date AND Time

I’m trying to create a formula that is conditional on both day and time. Specifically, if the current time is AFTER 1600 on a Friday and BEFORE …

I’m trying to create a formula that is conditional on both day and time. Specifically, if the current time is AFTER 1600 on a Friday and BEFORE …

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 …