Hi,
Can anyone help me with the following?
I have a workbook that will detail shift finish times and I'm hoping to create a formula or conditional format that can reference against a cell with the current time and update when the shift finish time is within -60mins/ -30mins and -15mins.
The current time cell is running from a macro that updates the current time every minute
Thank you
Typical:
=Cell shift time - cell with current time < 60
add formulas for 30 & 15 and replace the 60
Ben Van Johnson
Hi and thanks for the reply
The time cells are in 00:00:00 format so will a formula with <15 work or should it be in a similar format
Whatever formula you use, keep in mind that if you are referencing time, the cell will not automatically update on it's own, there will need to be some change in the workbook (or F9-calc)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks