 |
 | 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 / February 2008Calculating the number of minutes between days
I need to calculate the number of minutes between two times on two different days. For example: 2/6/2008 12:35 p.m. 2/8/2008 4:17 a.m. Any thoughts or direction I should go? Thanks much in advance! =A1-B1, Format Custom as [m]  SignatureKind regards, Niek Otten Microsoft MVP - Excel |I need to calculate the number of minutes between two times on two different | days. [quoted text clipped - 7 lines] | | Thanks much in advance! =A1-B1, Format Custom as [m] will work fine but remember to format your source cells how you want them to display. Do not type am or pm if entering time. Signaturejoec > =A1-B1, Format Custom as [m] > [quoted text clipped - 9 lines] > | > | Thanks much in advance! Why not, Joe? If the OP wants 11:00 PM for one of her input cells and types in only 11:00, the time would be treated as 11:00 instead of 23:00. I happen to prefer using 24 hour time, but there's no reason not to use 12 hour times. SignatureDavid Biddulph > =A1-B1, Format Custom as [m] will work fine but remember to format your > source cells how you want them to display. Do not type am or pm if > entering > time. =(A2-A1)*1440 SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk >I need to calculate the number of minutes between two times on two >different [quoted text clipped - 8 lines] > > Thanks much in advance! =(SUBSTITUTE(A1,".","")-SUBSTITUTE(A2,".",""))*1440 assuming A1 and A2 contain the 2 dates If the dates have no decimal points around am and pm you could simply subtract one from another and multiply the result by 1440 > I need to calculate the number of minutes between two times on two different > days. [quoted text clipped - 7 lines] > > Thanks much in advance! |
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.