Excel 2007 : "IF" function and time format

[mzbreski]

I am working to update weekly data for physicians viewing a Web-based training module. Data is sent to me every monday and I import into a master file to keep a running total. One of the fields in the spreadsheet sent to me is "time that the training module is viewed" (format: custom, h:mm:ss). The physicians are timed and only get credit for viewing if they are in the module for a minimum of 5 minutes. To track credit for viewing, I want to create a field with a logic "if" function stating "if the time viewed is 5 minutes or greater, then return '1', if the time viewed is less than 5 minutes, then return '0'". I have entered the function "=IF(K3<"0:05:00",1,0)" and I cannot get it to work properly. Any help on this will be appreciated.

[arthurbr]

Hi and welcome to the board

Try

=IF(K3<TIME(0,5,0),1,0)

[Fotis1991]

Hi mzbreski and welcome to forum.

Try this:

=IF(K3<"00:05";1;0)

Hope to helps you

[mzbreski]

You are an absolute savior. I dont know if I ever would have figured that one out. I love working with formula puzzles like this and can usually figure things out with time, but this one had me stumped. THANK YOU!!

[arthurbr]

You're welcome

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save