Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excell - Compare cell/Current Time
Name: GRob Date: March 18, 2004 at 21:22:14 Pacific OS: WIN2K CPU/Ram: P4, 512
Comment:
We are using an Excell spreadsheet to track Estimated Arrival Times. Is there a way, possibly using Conditional Formatting, to compare the time in a cell to current time each time spreadsheet is opened - then change font if ETA is passed? Thanks
Name: chnos Date: March 18, 2004 at 23:02:57 Pacific
Reply:
of course yes. But remember that row will be recalculated at reopen.. To do that compare now()extracting hour/minute to ur recepting time.
0
Response Number 2
Name: GRob Date: March 19, 2004 at 00:36:27 Pacific
Reply:
If the time is input in 24hr time (2300 = 11:00 pm), how do I extract hour/minute, then use the result to compare to now() for the Conditional Formatting?
0
Response Number 3
Name: chnos Date: March 19, 2004 at 01:28:22 Pacific
Reply:
compare hour(now()) to ur time enter as hh:mm. A substracion between both confirms a difference.
0
Response Number 4
Name: GRob Date: March 19, 2004 at 01:30:29 Pacific
Summary: You've asked a tricky one . What you are asking is for excel to have access to dynamic stored information outside the application .Excel then needs to reference this information when the file is opene...
Summary: Hi there. I'm hoping someone can help me simplify a function that I'm using in excel. Basically I have rows of data, e.g. Row 1 - XOOXO Row 2 - XXXXO Row 3 - OOXOO and so forth. What I want to know is...
Summary: I know how to fill in the current time or the date. I also know how to attach a macro to a button. But how can i create a macro so that when a command button is pressed it fills in the current time or...
0 
time display missing in O...
