Thread: how to add a time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JohnC
 
Posts: n/a
Default 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





Reply With QuoteReply With Quote