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
|