AM and PM

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Loi - 10 Sep 2004 19:26 GMT

Hi,
I have a fomular which uses for subtract time.

Ex: D2 - C2 at E2

Ex: 7:00 Am - 8:00 Am = 1.00 hr.

The problem is that I can not subtract AM toPM hrs if i
use this format: 7:00 Pm = 19:00

Ex: 23:45 - 1:00 Am = ???.
23:45 is 11:45 PM

Thank you
Loi

Reply to this Message

Frank Kabel - 10 Sep 2004 20:00 GMT

Hi
try
=D2-C2+(D2<C2)

Signature

Regards
Frank Kabel
Frankfurt, Germany

> Hi,
> I have a fomular which uses for subtract time.
[quoted text clipped - 11 lines]
> Thank you
> Loi

Reply to this Message