"IF" function with time

Closed

Gary_Georgian

Posts: 1
Registration date: Tuesday July 26, 2016
Status: Member
Last seen: July 26, 2016

- Jul 26, 2016 at 03:18 PM

Hello,

I'm trying to do a function which will say if 0:15 minutes or less, the value will be 0 and for every 0:15 minutes the value is 1 for every 15 minutes. Any suggestion what I should be doing?

"IF" function with time
If function for time range in excel - Guide
Nested IF functions using time values ✓ - Forum - Office Software
IF functions with TIME functions ✓ - Forum - Office Software
If function with time - Forum - Excel
Which function will you use to enter current time in a worksheet cell ✓ - Forum - Office Software

Subscribe To Our Newsletter!