IF functions with TIME functions
Solved/Closed
Kabosh
-
Jul 25, 2011 at 08:25 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 28, 2011 at 09:00 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 28, 2011 at 09:00 PM
Related:
- Which function will you use to enter current time in a worksheet cell
- Transfer data from one excel worksheet to another automatically - Guide
- How to enter @ in laptop - Guide
- Popcorn time - Download - Movies, series and TV
- How to change time in whatsapp - Guide
- Disk boot failure insert system disk and press enter - Guide
4 replies
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Jul 26, 2011 at 12:55 AM
Jul 26, 2011 at 12:55 AM
there are lots of error in syntax of your formula
for time value correct syntax is
=Timevalue("time text") e.g. =TIMEVALUE("0:0:0")
and for if statement it is
= IF(Logical_text, [Value_if_true], [Value_if_false])
there are "," (without "") and you used ";"
for time value correct syntax is
=Timevalue("time text") e.g. =TIMEVALUE("0:0:0")
and for if statement it is
= IF(Logical_text, [Value_if_true], [Value_if_false])
there are "," (without "") and you used ";"
RWomanizer, thank you for your time.
I managed to figure out the problem, as you said, it was just syntax, I'm using Office 2007, the ("") in TIMEVALUE aren't needed and the "," in the IF are replaced by ";" but the you "outside view" helped me figure out the problem and the formula is working ok now, thank you once again. :)
I managed to figure out the problem, as you said, it was just syntax, I'm using Office 2007, the ("") in TIMEVALUE aren't needed and the "," in the IF are replaced by ";" but the you "outside view" helped me figure out the problem and the formula is working ok now, thank you once again. :)
Hezekiah123
Posts
4
Registration date
Tuesday July 26, 2011
Status
Member
Last seen
July 26, 2011
Jul 26, 2011 at 04:53 AM
Jul 26, 2011 at 04:53 AM
I am looking for a formula to change a condition based on the time of day. Essentially, before 1pm I would like the formula to be:
=((I12/100)*25)/D12
After 1pm I would like the formula to be
=((I12/100)*25)/B12
I tried various ways with "=if(now()> ..." formulas to no avail because of the way Excel handles Now().
=((I12/100)*25)/D12
After 1pm I would like the formula to be
=((I12/100)*25)/B12
I tried various ways with "=if(now()> ..." formulas to no avail because of the way Excel handles Now().
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Jul 28, 2011 at 09:00 PM
Jul 28, 2011 at 09:00 PM
@Hezekiah123
Why not try some thing like
=IF(HOUR(NOW()) >=13, ((I12/100)*25)/B12 , ((I12/100)*25)/D12 )
Why not try some thing like
=IF(HOUR(NOW()) >=13, ((I12/100)*25)/B12 , ((I12/100)*25)/D12 )
