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
|