View Single Post
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

One more version that might be even more clear:

=B1-A1+IF(B1<A1,1,0)

Still following JE's rules:
A1: <start time
B1: <end time



John Harris wrote:

I know this has to be easy. I have a start time and an end time. I need the
difference in hours and minutes. I used the examples in the help, but it
converts it to text and then it won't add. Anyone?

TIA

JC


--

Dave Peterson