View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jonathan Cooper
 
Posts: n/a
Default how to add a time

Assuming your calculation will always be within the same calendar day, try
this:

=HOUR(H19)-HOUR(I19)

"JohnC" wrote:

7:00 AM 5:00 PM should = 10 hrs

However if i use the forumla posted by Oscar
=SUM(I19-H19*24)

I would get -6.291666667

Yikes