Time Completed
But why isn't it early? How does excel know you want it to be 2hrs late? A
simple solution would be to enter the date and time: Format the time input
cells to dd/mm/yy hh:mm. But be aware the formula will only calculate up to
23 hours 59 minutes.
"hawaiiham2000" wrote:
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.
|