CODEWITHSUNDEEP
exceldatetime
silverkid
silverkid

Reputation: 9563

Excel formula for time comparision

while writing an formula for data in a excel cell

if an excel cell contains an integer we can use the statement if (cell.value > 100 )

but when the excel cell contains a time duration in the format min:sec and we have to compare value greater than 3 minutes duration how to write the statement.

if (cell.value > 03:00 )

is this statement allowed in a formula, or is there a better way to express this ?

Upvotes: 1

Views: 510

Answers (2)

user180100
user180100

Reputation:

Assuming your minute cells are correct Excel timestamp (ie. hh:mm:ss formated mm:ss), you can use =MINUTE(XX) > 3

Upvotes: 0

Yngve Hammersland
Yngve Hammersland

Reputation: 1674

Use:

if(cell.value > Time(0,3,0))

Upvotes: 2

Related Questions