-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
time value
-
C
If statement to give a 'yes' or 'no' if a time fall between a range
Hi all, I am trying to get a yes/no answer if a cell is between a time range. It is set up as a table on Office 365. I have tried IF and IFS statements with both AND and TIMEVALUE in it. I have attached a screen grab of what i'm working with at the moment. Any help is greatly appreciated. Chris- chrisb360
- Thread
- and if if statement ifs time time value timevalue
- Replies: 7
- Forum: Excel Questions
-
H
Distinct Count based on two criteria (time involved)
Please see the spreadsheet below. I've tried multiple array formulas with combination of sum/sumproduct/if/countif and no luck. I am trying to count the number of distinct ANI's that have a call time of greater than 0:00:29 and are of the campaign, Inbound - Live TV5. I've been at this for...- honestabe1982
- Thread
- array count distinct excel time value
- Replies: 6
- Forum: Excel Questions
-
D
time values in if formulas excel 2007
Hi See below a start and finish time of a shift. For John Doe I want the hours worked to read 24:00. See formulas used in the 2 hours worked for John and Peter. <tbody> Start Finish Name Hours worked 14:00 Sleep over 14:00 John Doe 00:00 16:00 D/D 21:00 Peter Doe 05:00 </tbody>...- D sweetman
- Thread
- if formula time value
- Replies: 19
- Forum: Excel Questions
-
M
Text to Time Formula Problem
Hi all, there is formula to text in to time =+Text($D1,"hh:mm AM/PM) if I use this in a blank cell show 12:00 AM why? Thanks in Advance!- meakashgfx
- Thread
- time value
- Replies: 2
- Forum: Excel Questions
-
Is 6513 mins = 108 hrs 55 mins?
Is 6513 mins = 108 hrs 55 mins- pedie
- Thread
- time value
- Replies: 10
- Forum: Excel Questions
