How do I enter a time formula into a worksheet that determines if.

Lee

Posts: n/a

How do I enter a time formula into a worksheet that determines if.

How do I, set about entering a formula within a worksheet that determines if
the Time is greater or less that the time in a certian cell;
eg =if(now()K17,"then display this","") K17 holding the Value 08:30 AM
formated to time

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can you enter a formula in a cell to run a macro?	Nevaeh	Excel Worksheet Functions	2	February 14th 05 11:51 PM
Am trying to make a time sheet and having problems with a formula.	godnight	Excel Worksheet Functions	2	February 14th 05 01:21 PM
Automatically enter date and time but only update once.	PM	New Users to Excel	3	January 21st 05 07:47 AM
What is the formula for getting time difference e.g. ("4 hrs 15 m.	Sandeep Manjrekar	Charts and Charting in Excel	3	December 4th 04 05:18 AM
Excel Time Duration Formula	Jackson	Excel Worksheet Functions	2	November 4th 04 11:14 PM

All times are GMT +1. The time now is 03:02 AM.

Menu

About Us