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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SET A CONDITION
Hi,
From your example, with the start time in cell A1 and end time in cell A2, =A2-A1 would produce a result of 2 (or times 24 = 48 hours) For the formula : =IF((A2-A1)*2424,"Exceeds 24 H",(A2-A1)*24) should do the job ... HTH Cheers Carim |
Reply |
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 |