Try. 24 should not be a numeric but should be in time format//
=IF(E24TIME(24,0,0),"NO","Yes")
If this post helps click Yes
---------------
Jacob Skaria
"Joshua" wrote:
Thank you that helped alot
I also want to know if anything has gone over a 24hr time limit
before I had it calculate =IF(C324,"NO","YES")
so if C3 was 25:00 it would give me a NO or 23:00 a yes
right now it gives me all YES even if it is over 24
Do I have to change the format of =IF cell or input a new formula
Thanks for your time
"Bernard Liengme" wrote:
=B1-A1
Format the cell with custom format [h]:mm to see 2:30 or 24:30, or with
[hh]:mm to see 02:30 or 24:30
The [ ] are needed to get Excel to display more that 24 hours
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Joshua" wrote in message
...
I am trying to get the difference between date and time into the hh:mm
format.
Example:
Start Date End Date Time taken to complete
7-1-09 8:00 AM 7-2-09 8:30 AM 24:30
How can i get it to calculate the difference between the date and the time