time
 

I am trying to subtract a beginning time from an ending time. If a3 is the
beginning and a4 is the ending, how should I set up those celsl and what
formula should I use to get the answer I would also like to total the total
time column. . I would prefer not to use military time if at all possible
since it would confuse the person who is inputting the times.
thanks in advance
bob

time
 

Bob,

Simply subtract them to get the difference but always later time - earlier
time

=B1-A1

The time format is irrelevant because that's just how you see it, the
underlying vlaue of the time doesn't alter.

Mike

"bob" wrote:

I am trying to subtract a beginning time from an ending time. If a3 is the
beginning and a4 is the ending, how should I set up those celsl and what
formula should I use to get the answer I would also like to total the total
time column. . I would prefer not to use military time if at all possible
since it would confuse the person who is inputting the times.
thanks in advance
bob

time
 

Bob,

I should have added it gets slightly more complicated for time before/after
midnight so a formula that copes with both is:-

=(B1-A1+(B1<A1))*24

a1= start time
b1 = end time

"bob" wrote:

I am trying to subtract a beginning time from an ending time. If a3 is the
beginning and a4 is the ending, how should I set up those celsl and what
formula should I use to get the answer I would also like to total the total
time column. . I would prefer not to use military time if at all possible
since it would confuse the person who is inputting the times.
thanks in advance
bob

time
 

=Mod(B1-A1,1)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"bob" wrote in message
...
I am trying to subtract a beginning time from an ending time. If a3 is the
beginning and a4 is the ending, how should I set up those celsl and what
formula should I use to get the answer I would also like to total the
total
time column. . I would prefer not to use military time if at all possible
since it would confuse the person who is inputting the times.
thanks in advance
bob

time
 

Thanks
bob


"bob" wrote in message
...
I am trying to subtract a beginning time from an ending time. If a3 is the
beginning and a4 is the ending, how should I set up those celsl and what
formula should I use to get the answer I would also like to total the
total
time column. . I would prefer not to use military time if at all possible
since it would confuse the person who is inputting the times.
thanks in advance
bob