how to add a time
 

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

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

how to add a time
 

It should be

=(I19-H19)*24


--

HTH

RP
(remove nothere from the email address if mailing direct)


"JohnC" wrote in message
...
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