how to add a time

J

JohnC

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
 
J

Jonathan Cooper

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

=HOUR(H19)-HOUR(I19)
 
B

Bob Phillips

It should be

=(I19-H19)*24


--

HTH

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