+ OR - TIME

H

Harald Staff

=B1-A1+(B1<A1)
og if you insist on formatting the result as requested
=(B1-A1+(B1<A1))*24&"HR'S"

HTH. Best wishes Harald
 
R

Richard - ExcelForums.com

=IF(B1>A1, B1-(A1-"00:00:01"), A1-(B1-"00:00:01")

I use this. Always keeps the time positive. i.e. 4am -> 1am woul
be 3 hours

The addition of seconds is becuase sometime Excel thought 11am minu
11am would be a negative number
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Someone knows how to add hyperlinks to hours to schedule an appointment? 0
Min, Max 3
Convert string to military time string 14
Add time when working 3rd shift 0
TIME CALCULATION 8
Date Time decimal value help please 1
IF function 7
Count occurences of time 1

Top