Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SET A CONDITION
I have the total number of hours and minutes between two dates and
times. but I also need to set a condition that checks whether the hours have exceeded 24 hours. For e.g. if 23/10/05 10:30 (Start time) 25/10/05 10:30 (End time) Total no of hours is 47hours and 45 minutes. I want to set a condition that will check if the hours exceed 24 hours if so then comes with a message. I have tried IF function but it doesnot check the minutes. Please help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
Condition Sum | Excel Worksheet Functions | |||
Condition 1 overules condition 2? | Excel Worksheet Functions | |||
I need 4 condition for condition formatting | Excel Programming |