time

[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

 

[Guest]

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

 

[Guest]

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 Phillips]

=Mod(B1-A1,1)

--
---
HTH

Bob

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

 

[bob]

Thanks
bob