If you don't include a date, how would you want to decide whether it's 2
hours late or 22 hours early? Do you want to say that it can't be 12 hours
or more early or late?
--
David Biddulph

"hawaiiham2000" wrote in message
...
We are getting warmer... but if the due time is 11pm and it is completed
at 1
am, we want that to be 2 hrs late, not 22 hrs early. Do we have to
include a
date?

"Ron@Buy" wrote:

Try this:
Enter start time in A1 and completed time in B1 (enter hours and minutes
seperated by :)
In C1 enter formula:
=IF(B1A1,TEXT(B1-A1,"h:mm")&" late",TEXT(A1-B1,"h:mm")&" early")
Hope this helps


"hawaiiham2000" wrote:

And how could it be displayed in minutes?

"hawaiiham2000" wrote:

I am trying to figure out a formula to use to show if a project is
completed
on time. If the due time is 11pm and the project is completed at 9pm
it
could show that it was on time by 2 hours; and if the project is not
completed until 1am, how could I show that it was 2 hours late? Any
help
would be appreciated. Thanks.