Thread: SET A CONDITION
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] princy_varghese@hotmail.com is offline
external usenet poster
 
Posts: 3
Default 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