Time

Question

Hi - I'm trying to put together a very basic spreadhset that show if someone is here or not. I can't seem to find a formula that will just show time now without the day's date. so say for example my shift was 9.00-17.00 and it was 14.15 i want to show that I am availible. I'm just using a basic V lookup and IF and i'm stumped. In Column A - Name, Column B - Start Time, Column C - End Time, Column D - time now, Column E - should show Column A contents or remain blank

Answer

To get just the current time, try this:

In column D use the formula for current date and time: =NOW()

In column E use the formula for current day: =TODAY()

In column F subtract the difference i.e. =D2-E2

In column G use and if then formula:

=IF(F2>B2,IF(F2<C2,"AVAILABLE","NOT AVAILABLE"),"NOT AVAILABLE")

-Craig