Help with =MOD

JR · Feb 23, 2006

Hello,

I am using =MOD(B6-E6,1) to subtract time, however I am receiving a 59 hour
thing if the time is under. How do I use =MOD for same day returns?

Thanks

8:00 7:27 59:27
8:00 17:05 9:05
8:00 18:30 10:30

Biff · Feb 23, 2006

Hi!

I am receiving a 59 hour thing if the time is under.

Under what?

B6 = 7:27
E6 = 8:00

=MOD(B6-E6,1) returns 23:27

Biff

JR · Feb 23, 2006

switch the positions of the times. Put 7:27 in E6 and 8:00 in B6

Biff · Feb 23, 2006

Then the result is 0:33.

Biff

JR said:
switch the positions of the times. Put 7:27 in E6 and 8:00 in B6