Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing 2 dates and times
Hi
I have a spreadsheet with 5 columns: A = date an e-mail received B = time e-mail received on that date C = date e-mail replied to D = time e-mail replaied to on that date e-mail E = was the e-mail replied to within agreed time limit? The agreed time limit is 24 hours. I'd be happy enough coming up with a formula to input Y or N into colmun E, if I only knew how to subract a time AND date from another time and date. Can anyone advise, please? Many thanks. Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing times.. | Excel Worksheet Functions | |||
Comparing two times | Excel Discussion (Misc queries) | |||
Comparing Calculated Times | Excel Worksheet Functions | |||
Comparing Times | Excel Discussion (Misc queries) | |||
Comparing Times | New Users to Excel |