Time help required

[nick_bishop68]

I have a “time taken” to work sheet set up but want to add an additional feature. Its set up to log in and log out and works out the time taken to process. I want to add a feature that once logged in, if not logged out in under 1 hour either a cell or the row turns red as a warning.

When anything (“text”) is entered into a cell D5 (logged in),then the current time is entered into E5.
=IF(D7<>"",IF(E7="",NOW(),E7),"")<o></o>
Then, when logged out, by entering “text” into F5, thecurrent time is entered into G5.<o></o>
=IF(F5<>"",IF(G5="",NOW(),G5),"")<o></o>
The time taken is calculated in Q5. <o></o>
=IF(G5="","",(G5-E5))<o></o>
How do I turn a cell or cell or row RED (or another alerting method)if cell E5 is +1hour and F5 (and G5) are blank (not logged out)?<o></o>

 

[FDibbins]

Time is just a number, and is a fraction of 1 day. So 1 hour is 1/24.

Does that help?