Count down timer clock with alarm. please help.

[carhoon13]

Hi all i am very new to this and just started using excel,

So i am using excel as a journey management worksheet, i have the actual time in E column(as i enter it manually) and time taken to travel in F column and then ETA in G column and so i get ETA with this formual G=E+F, i would like it if i could get F column to be a live clock and count dow the time i put in there as Hours and minutes, and when it gets to 0 highlight the row red to alert me they are out of time.

Please remember i have very basic knowlagde of excel, any help will be great

Thank you phillip.

[Swindonwhite]

you can get actual time by using
=Now()

from this you can work out what you need by getting the difference.

Cheers

[carhoon13]

Ok then thankx,

but where abouts do i put that formula ?