Thread: Time Completed
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hawaiiham2000 hawaiiham2000 is offline
external usenet poster
 
Posts: 15
Default Time Completed

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.