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
|