time

  • Thread starter Thread starter bob
  • Start date Start date
B

bob

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
 
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,

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
 
=Mod(B1-A1,1)

--
---
HTH

Bob

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