samedi 2 janvier 2016

If statement using time format in Excel

I'm trying to set up something in excel where in cell F4 is a calculated time, in the format of something like this: 9:30:00. (Hours:Minutes:Seconds) Cell e8 is a static number that never changes, unless you manually change the cell lets say it's set as 10.

I am trying to set up a cell that looks at call f4, checks if its under 9:00:00 and if it is then times cell e8 by cell f4, if it's over 9 simply times cell e8 by a static number of 8.

my current code is t working,

=IF(f4>9:00, e8*9, e8*f4)

Aucun commentaire:

Enregistrer un commentaire