Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to calculate Date & Time differences
Please help! :) I have created an Excel spreadsheet that tracks items from a SQL database. One of the things I need to keep track of is when one of the cells in the Date & Time column is within one hour from the current time. I know you can setup conditional formating to change the cell color. However, what I am looking for is some type of formula that will take data from the Date & Time colum and subtract the current time. If the result is less than 1 hour I would like the cell with the scheduled date to turn Yellow. Below is an example of the results I am looking for. If possible I would like to have the entire formula in conditional formating so that I do not have to have the current time shown on the spreadsheet. Date & Time Current Time Result 10/03/05 01:00PM 10/03/05 11:00AM No Action 10/03/05 01:00PM 10/03/05 12:05PM Date & Time cell turns Yello Thanks for the help! Robs -- robs ------------------------------------------------------------------------ robs's Profile: http://www.excelforum.com/member.php...fo&userid=4098 View this thread: http://www.excelforum.com/showthread...hreadid=472878 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date & time | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
Calculate time | Excel Discussion (Misc queries) | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
calculating date time ranges | Excel Worksheet Functions |