+ OR - TIME

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WILLIAM - 09 Oct 2004 18:17 GMT

IS THERE A FORMULA TO + OR- TIME LIKE 11:PM TO 1:00AM = 2HR'S

Reply to this Message

Frank Kabel - 09 Oct 2004 18:47 GMT

Hi
use
=(A2-A1)*24
and format the resulting cells as 'Number'

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> IS THERE A FORMULA TO + OR- TIME LIKE 11:PM TO 1:00AM = 2HR'S

Reply to this Message

Harald Staff - 10 Oct 2004 16:44 GMT

=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

> IS THERE A FORMULA TO + OR- TIME LIKE 11:PM TO 1:00AM = 2HR'S

Reply to this Message

Richard - ExcelForums.com - 10 Oct 2004 22:10 GMT

=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

Reply to this Message