Help with =MOD
 

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

Help with =MOD
 

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" wrote in message
...
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

Help with =MOD
 

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

"Biff" wrote:

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" wrote in message
...
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

Help with =MOD
 

Then the result is 0:33.

Biff

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

"Biff" wrote:

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" wrote in message
...
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