 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / July 2007time
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 > 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 [quoted text clipped - 3 lines] > thanks in advance > bob 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 > 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 [quoted text clipped - 3 lines] > thanks in advance > bob =Mod(B1-A1,1)  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >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 [quoted text clipped - 4 lines] > thanks in advance > bob Thanks 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 [quoted text clipped - 4 lines] > thanks in advance > bob |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.