software

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?

Thanks8:007:2759:27
8:0017:059:05
8:0018:3010:30

Hi!

gt;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

quot;JRquot; gt; wrote in message
...
gt; Hello,
gt;
gt; I am using =MOD(B6-E6,1) to subtract time, however I am receiving a 59
gt; hour
gt; thing if the time is under. How do I use =MOD for same day returns?
gt;
gt; Thanks
gt;
gt;
gt; 8:00 7:27 59:27
gt; 8:00 17:05 9:05
gt; 8:00 18:30 10:30
gt;
gt;
gt;
switch the positions of the times. Put 7:27 in E6 and 8:00 in B6

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; gt;I am receiving a 59 hour thing if the time is under.
gt;
gt; Under what?
gt;
gt; B6 = 7:27
gt; E6 = 8:00
gt;
gt; =MOD(B6-E6,1) returns 23:27
gt;
gt; Biff
gt;
gt; quot;JRquot; gt; wrote in message
gt; ...
gt; gt; Hello,
gt; gt;
gt; gt; I am using =MOD(B6-E6,1) to subtract time, however I am receiving a 59
gt; gt; hour
gt; gt; thing if the time is under. How do I use =MOD for same day returns?
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt;
gt; gt; 8:00 7:27 59:27
gt; gt; 8:00 17:05 9:05
gt; gt; 8:00 18:30 10:30
gt; gt;
gt; gt;
gt; gt;
gt;
gt;
gt;

Then the result is 0:33.

Biff

quot;JRquot; gt; wrote in message
...
gt; switch the positions of the times. Put 7:27 in E6 and 8:00 in B6
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; gt;I am receiving a 59 hour thing if the time is under.
gt;gt;
gt;gt; Under what?
gt;gt;
gt;gt; B6 = 7:27
gt;gt; E6 = 8:00
gt;gt;
gt;gt; =MOD(B6-E6,1) returns 23:27
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;JRquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hello,
gt;gt; gt;
gt;gt; gt; I am using =MOD(B6-E6,1) to subtract time, however I am receiving a 59
gt;gt; gt; hour
gt;gt; gt; thing if the time is under. How do I use =MOD for same day returns?
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; 8:00 7:27 59:27
gt;gt; gt; 8:00 17:05 9:05
gt;gt; gt; 8:00 18:30 10:30
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;