You're right. I think a date has to be included.

This is the scenario:

The deadline is 11 p.m. each night. We want to figure the out the total
minutes late or early for each project and eventually then be able to Sum
those and come up with an average.


"David Biddulph" wrote:

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.